请问有多条记录如何取第一条数据？

[rocket204]

用户id 姓名 手机号码 备注
0001 张三 13578782222 a
0001 张三 13578782223 b
0001 张三 13578782224 C
0002 李四 13890000111 a
0002 李四 13890000112
0003 王五 19890000001 M
0003 王五 19890000002 K


我想要的结果是

用户id 姓名 手机号码 备注
0001 张三 13578782222 a
0002 李四 13890000111 a
0003 王五 19890000001 M


谢谢各位！

[minsic78]

参考下分析函数row_number

[一名即将失业的db]

with tmp as (select '1' as id1,'a' as name1 ,'@' as addr , '26a' as value1 from dual union all select '1' as id1,'a' as name1 ,'@' as addr , '26b' as value1 from dual union all select '2' as id1,'a' as name1 ,'@' as addr , '27a' as value1 from dual union all select '2' as id1,'a' as name1 ,'@' as addr , '271' as value1 from dual ) select id1,name1,addr,min(value1) from tmp group by id1,name1,addr

[rocket204]

引用 2 楼 biubiu灰 的回复:

with tmp as
(select '1' as id1,'a' as name1 ,'@' as addr , '26a' as value1 from dual
union all
select '1' as id1,'a' as name1 ,'@' as addr , '26b' as value1 from dual
union all
select '2' as id1,'a' as name1 ,'@' as addr , '27a' as value1 from dual
union all
select '2' as id1,'a' as name1 ,'@' as addr , '271' as value1 from dual
)
select id1,name1,addr,min(value1)
from tmp
group by id1,name1,addr

厉害，谢谢！