比如,有一张表没有id自增序列,那么在写翻页的sql时就需要用rownum
select * from (select rownum as mynum,u.* from YW_DEVICES u) where mynum>=21 and mynum<41
注意:select rownum as mynum,u.* from YW_DEVICES u 中为u.*而不能只写* ,否则会报错。
比如,有一张表没有id自增序列,那么在写翻页的sql时就需要用rownum
select * from (select rownum as mynum,u.* from YW_DEVICES u) where mynum>=21 and mynum<41
注意:select rownum as mynum,u.* from YW_DEVICES u 中为u.*而不能只写* ,否则会报错。