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)
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)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货