分页SQL

MySQL：
$limit = $page* $pagesize.",".$pagesize;
select *
from (select t1.*, t2.intro, t3.ul_size, t3.ul_name, t4.user_name
from work as t1
left join work_extra as t2 on t1.wid = t2.wid
join uploads as t3 on t1.wid = t3.ulid
join member as t4 on t1.uid = t4.uid
where t3.ul_type = '3'
and t1.status = '1') t
where wid in (1, 2, 3)
order by enjoyed desc limit 0, 6

Oracle：
//当前页起始游标
$startPoin = ($page-1)*$pagesize+1;
//当前页结束游戏标
$endPoin = $page*$pagesize;
select *
from (select row_number() over(order by a.Sub_Time desc) row_num,
a.action_id,
d.circle_id,
d.circle_image,
a.title,
to_char(a.start_time, 'yyyy-mm-dd') as start_time,
to_char(a.end_time, 'yyyy-mm-dd') as end_time,
a.view_count,
a.sub_time,
nvl(b.messagenum, 0) as messagenum,
nvl(c.joinnum, 0) as joinnum
from Action_Info a,
(select Action_ID, count(User_ID) as messagenum
from Action_Feedback
group by Action_ID) b,
(select Action_ID, count(User_ID) as joinnum
from Action_Join
group by Action_ID) c,
Circle_Info d
where a.Action_ID = b.Action_ID(+)
and a.Action_ID = c.Action_ID(+)
and a.circle_id = d.circle_id(+)
and a.User_ID = '$userID')
Where row_num between $startPoin And $endPoin
[img][/img][img][/img][img][/img][img][/img][img][/img]