select * from `secondbuy_modelorder` ords,`traveler_info` infos,`secondbuy_airmodel` manag
where ords.`travel_infoid` = infos.`travel_infoid`
and ords.`secondmodelid` = manag.`secondmodelid`
and ords.`pay_stat` = '1'该SQL语句我想让他先排序,再分页,该怎么写呢。用的是MySql数据库
where ords.`travel_infoid` = infos.`travel_infoid`
and ords.`secondmodelid` = manag.`secondmodelid`
and ords.`pay_stat` = '1'该SQL语句我想让他先排序,再分页,该怎么写呢。用的是MySql数据库
你可以先排序要查询的数据,然后将其作为内嵌视图,然后再外层分页就能够达到效果了
可是这里是oracle板块..............
from (select row_.*, rownum rownum_
from (select XXX_1,XXX_2 from table_XX
where ~~~~~~~~~~~~
order by r.createdate desc) row_
where rownum <= XXYY )
where rownum_ > XXAA
-----------------------------------
例如分页是20行为一页,
查第二页内容
XXYY:=40
XXAA:=20
分页 不清楚