select * from (SELECT ROWnum, ROWid,a.* FROM (SELECT * FROM ecc_bj.ecc_card ORDER BY issued_date) a where ROWnum<=40 and rowid>=20 ) 那这样也是一样的错误,我该怎么写呢?谢
select a.* from (SELECT rownum num,t.* FROM ecc_bj.ecc_card t where rownum <= 40 ) a where a.num>= 20
(SELECT ROWnum, ROWid,a.* FROM
(SELECT * FROM ecc_bj.ecc_card ORDER BY issued_date) a
where ROWnum<=40
and rowid>=20
)
那这样也是一样的错误,我该怎么写呢?谢
from (SELECT rownum num,t.* FROM ecc_bj.ecc_card t where rownum <= 40 ) a
where a.num>= 20