- 论坛徽章:
- 0
|
请大家帮忙看看这个sql如何实现?
如果我没有理解错的话:
应该下面的sql语句可以帮你搞定,如果搞定的话不要忘记谢谢我!
create table ipflows(ipname varchar2(15),groupname varchar2(10),flows number(2))
insert into ipflows values('lis','mis',27)
insert into ipflows values('aaron','mis',27)
insert into ipflows values('frank','mis',27)
insert into ipflows values('scott','mis',27)
insert into ipflows values('anny','sys',21)
insert into ipflows values('ahill','sys',22)
insert into ipflows values('alan','sys',23)
insert into ipflows values('geo','mis',24)
select ipname,groupname,flows
from ipflows
where flows =(select max(flows) from ipflow)
and rwonum < 4
结果:
ipname groupname flows (<n+1) n=3
lis mis 27
aaron mis 27
frank mis 27
---没有
---scott mis 27 |
|