查询数据的最大排序问题(只能用一条语句写)
CREATE TABLE hard (qu char (11) ,co char (11) ,je numeric(3, 0))
insert into hard values ('A','1',3)
insert into hard values ('A','2',4)
insert into hard values ('A','4',2)
insert into hard values ('A','6',9)
insert into hard values ('B','1',4)
insert into hard values ('B','2',5)
insert into hard values ('B','3',6)
insert into hard values ('C','3',4)
insert into hard values ('C','6',7)
insert into hard values ('C','2',3)
要求查询出来的结果如下:
qu co je
----------- ----------- -----
A 6 9
A 2 4
B 3 6
B 2 5
C 6 7
C 3 4
解答:
select * from hard a where (select count(*) from hard b
where a.qu=b.qu and b.je>=a.je)<=2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/240582/viewspace-970345/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/240582/viewspace-970345/