select * from (select ROWNUM, ... . . .) x where x.ROWNUM>=3
rownum不能用>操作只能用< or <=;你可以试试rowid。 select * from x where rowid>(select max(rowid) from x where rownum<=3);
select * from x minus select * from x where rownum<3
SELECT * FROM x WHERE rowid>=(SELECT * FROM X WHERE rownum<=3);
Michaelyfj(星星还是那颗星星) 这个方法可以: select * from x minus select * from x where rownum<3 =================================================== dtliupeng(吉利) 更好点吧。(*改成ROWID) SELECT * FROM x WHERE rowid>=(SELECT rowid FROM X WHERE rownum<=3); =================================================== 我觉得:用不等号是不是最好? SELECT * FROM x WHERE rowid!=(SELECT rowid FROM X WHERE rownum<=3);
错了,重发! Michaelyfj(星星还是那颗星星) 这个方法可以: select * from x minus select * from x where rownum<3 =================================================== dtliupeng(吉利) 更好点吧。(*改成ROWID) SELECT * FROM x WHERE rowid>=(SELECT rowid FROM X WHERE rownum<=3); =================================================== 我觉得:用不等号是不是最好? SELECT * FROM x WHERE rowid!=(SELECT max(rowid) FROM X WHERE rownum<4);
from
(select ROWNUM, ...
.
.
.) x
where x.ROWNUM>=3
select * from x where rowid>(select max(rowid) from x where rownum<=3);
minus
select * from x where rownum<3
WHERE rowid>=(SELECT * FROM X WHERE rownum<=3);
select * from x
minus
select * from x where rownum<3
===================================================
dtliupeng(吉利) 更好点吧。(*改成ROWID)
SELECT * FROM x
WHERE rowid>=(SELECT rowid FROM X WHERE rownum<=3);
===================================================
我觉得:用不等号是不是最好?
SELECT * FROM x
WHERE rowid!=(SELECT rowid FROM X WHERE rownum<=3);
Michaelyfj(星星还是那颗星星) 这个方法可以:
select * from x
minus
select * from x where rownum<3
===================================================
dtliupeng(吉利) 更好点吧。(*改成ROWID)
SELECT * FROM x
WHERE rowid>=(SELECT rowid FROM X WHERE rownum<=3);
===================================================
我觉得:用不等号是不是最好?
SELECT * FROM x
WHERE rowid!=(SELECT max(rowid) FROM X WHERE rownum<4);
只是
===========================================================
用不等号是不是最好?
===========================================================
的说法不正确吧?不是楼主所需要的。
select b.*
from
(select ROWNUM as yourow , a.* from youtable a) b
where b.yourow>3
from (select rownum row_id,
employeecode
from t_base_employee)
where row_id >=3;
WHERE rowid!=(SELECT rowid FROM X WHERE rownum<=3);select * from x
minus
select * from x where rownum<3;都可以!