insert into (eo,jo,po) values('A','2',6),下面类同。就是eo字段为char jo为char po为int
A 2 6
A 2 5
A 8 9
A 5 3
B 6 7
B 6 8
B 4 9
B 3 23
C 4 3
C 2 32
C 1 34
C 7 21
最后的结果为
A 8 9
A 2 6
B 3 23
B 4 9
C 1 34
C 2 32
求一句sql server语句对上面的字段排序成为上面的结果。麻烦各位大虾了
------解决方案--------------------
- SQL code
select * from SEELCT (row_number() over(partition by eo order by po desc)) numberid ,eo,jo,po from tb ) z where numberid <=2