table test :
colun : a, b, c, d, e, f, g 1 A 11 2 3 4 4
1 A 3 4 5 5
1 B 11 1 2 3 3
1 B 12 2 3 3 3要求查询结果为:1 A 11 2 3 4 4
1 B 11 1 2 3 3请问各位, 如何实现啊?
colun : a, b, c, d, e, f, g 1 A 11 2 3 4 4
1 A 3 4 5 5
1 B 11 1 2 3 3
1 B 12 2 3 3 3要求查询结果为:1 A 11 2 3 4 4
1 B 11 1 2 3 3请问各位, 如何实现啊?
from
(select a,b,c,d,e,f,g,row_number() over(partition by a,b order by c) rn from test) t where rn=1
楼上的正解
关键要注意partition by a,b order by c