下面是一条SQL语句,在Oracle里面运行得不到数据,请大家帮忙看一看,问题出在哪里?
select * from
(select * from ServiceInfo where OneID=5000 order by IsAgon desc,Agon desc) ss
where rownum >= 7 and rownum <=12
select * from
(select * from ServiceInfo where OneID=5000 order by IsAgon desc,Agon desc) ss
where rownum >= 7 and rownum <=12
(select rownum rid,A.* from ServiceInfo A where OneID=5000 order by IsAgon ,Agon desc) ss
where rid >= 7 and rid <=12
select * from tablename where rownum != 10;返回的是前9条记录。
不能用:>,>=,=,Between...and。由于rownum是一个总是从1开始的伪列。只能用
select *
from table_name
where rownum < N
minus
select *
from table_name
where rownum < M就可以选中 M 与 N之间的。