--三层吧 select * from (SELECT ROWnum ROWid,a.* FROM (SELECT * FROM tablename ORDER BY DATEField) a where ROWnum<=40 ) where ROWid>=20
select * from (SELECT rownum rid ,a.* FROM (SELECT * FROM tablename ORDER BY DATEField)a where rownum <=40 ) where rid>=20
请问为何这样做,会提示: can not select rownum from view with distinct,group by, etcselect * from (SELECT ROWnum, ROWid,a.* FROM (SELECT * FROM ecc_bj.ecc_card ORDER BY issued_date) a where ROWnum<=40 ) where ROWid>=20这样写对吧
select * from
(SELECT ROWnum ROWid,a.* FROM
(SELECT * FROM tablename ORDER BY DATEField) a
where ROWnum<=40
)
where ROWid>=20
(SELECT ROWnum, ROWid,a.* FROM
(SELECT * FROM ecc_bj.ecc_card ORDER BY issued_date) a
where ROWnum<=40
)
where ROWid>=20这样写对吧