用来分页的SQL语句

[zhouxingyu896]

用来分页的SQL语句

[xiaomaomi1027]

SQLServer分页:

select top 页大小 * from

(select top 页大小*页码 from 表名 order by 排序字段 desc) as 表的别名

order by 排序字段 ASC


Mysql分页:

select * from tablename order by tablefield limit 5,5
注:取第5条到第10条。

Oracle分页:

select rownum A.*
from(select * from tablename
where tablefield1 = 'offline'
order by tablefield2 aesc)


select rownum A.*
from(select * from tab_name)
where tablefield1 = 'offine'
order by tablefield2 aesc)