select * from table_name where rownum=10;???? 不行。一条记录都不返回。select * from table_name where rownum<10; 返回前十条记录,但不满足要求。select * from (select rn,a.* from table_name a) where rn>=10 and rn<=20 请问rn是什么?
select * from (select rownum rn,a.* from table_name a) where rn>=10 and rn<=20
select * from (select rownum rn,a.* from table_name a) where rn>=10 and rn<=20这样会多出一列出来。
不行。一条记录都不返回。select * from table_name where rownum<10;
返回前十条记录,但不满足要求。select * from
(select rn,a.* from table_name a)
where rn>=10 and rn<=20
请问rn是什么?
(select rownum rn,a.* from table_name a)
where rn>=10 and rn<=20
(select rownum rn,a.* from table_name a)
where rn>=10 and rn<=20这样会多出一列出来。