select * from (select t.* ,rownum rn from your_table t) where rn > xx and rn < xx
select * from (select rownum sun,T003.* sun from table T003) where sun >(select sun from (select T001.*,rownum sum from table T001) T002 where T002.name='name' and T002.age='age' and T002.job='job')
可不可以用到rowid这个东东来唯一标识下查到了哪里
Select * From (Select Rownum num,a.* From test_prince a Where Rownum <5) b Where b.num >3;可以分页查询
--第一天查询语句 ,查完后 记住 NUM 值 SELECT ROWNUM NUM,T.* FROM TABLE_NAME ORDER BY name,age,job; --第二天查询语句 ,WHERE 条件写入昨天的NUM值 SELECT * FROM(SELECT ROWNUM NUM,T.* FROM TABLE_NAME ORDER BY name,age,job) WHERE NUM > 昨天 NUM值
--第一天查询语句 ,查完后 记住 NUM 值 SELECT ROWNUM NUM,T.* FROM TABLE_NAME T ORDER BY name,age,job; --第二天查询语句 ,WHERE 条件写入昨天的NUM值 SELECT * FROM(SELECT ROWNUM NUM,T.* FROM TABLE_NAME T ORDER BY name,age,job) WHERE NUM > 昨天 NUM值忘写 别名了
(select t.* ,rownum rn from your_table t)
where rn > xx and rn < xx
(Select Rownum num,a.* From test_prince a Where Rownum <5) b
Where b.num >3;可以分页查询
SELECT ROWNUM NUM,T.* FROM TABLE_NAME ORDER BY name,age,job;
--第二天查询语句 ,WHERE 条件写入昨天的NUM值
SELECT *
FROM(SELECT ROWNUM NUM,T.* FROM TABLE_NAME ORDER BY name,age,job)
WHERE NUM > 昨天 NUM值
SELECT ROWNUM NUM,T.* FROM TABLE_NAME T ORDER BY name,age,job;
--第二天查询语句 ,WHERE 条件写入昨天的NUM值
SELECT *
FROM(SELECT ROWNUM NUM,T.* FROM TABLE_NAME T ORDER BY name,age,job)
WHERE NUM > 昨天 NUM值忘写 别名了