3,490
社区成员
发帖
与我相关
我的任务
分享
--第一种写法
select s.id,s.content,s.scount,mc.c from sms_1204 s,
(
select mpage.* from
(
select mid.*,rownum as rn from
(
select m.id,count(*) c from msg_1204 m where m.mstatus = 1 group by m.id
)mid
where rownum <=2000
)mpage
where mpage.rn >=0
)mc
where mc.id = s.id and s.fls_number=1
--第二种写法
select s.id,s.content,s.scount,mc.c from sms_1204 s,
(
select m.id,count(*)c from msg_1204 m ,
(
select spage.* from
(
select scondition.id, rownum as rn from
(
select s.id from sms_1204 s where s.fls_number = 1
)scondition
where rownum <=2000
)spage where spage.rn >=0
)sid
where sid.id = m.id and m.mstatus=1
group by m.id
) mc
where mc.id = s.id