表
id name value1 jack 20
2 jack 30
3 tom 29
4 tom 12
5 linco 4求条语句
可显示为
id name value
1 jack 20 (或 2 jack 30)
3 tom 29 (或 4 tom 12)
5 linco 4谢谢!
id name value1 jack 20
2 jack 30
3 tom 29
4 tom 12
5 linco 4求条语句
可显示为
id name value
1 jack 20 (或 2 jack 30)
3 tom 29 (或 4 tom 12)
5 linco 4谢谢!
from
(select id,name,value,row_number() over(partition by name order by id) rn
from table_name) t where rn=1