17,377
社区成员
发帖
与我相关
我的任务
分享
select
*
from
(select
a.resultid,
a.dataid,
a.tiptext,
b.title,
b.content,
b.issuetime,
b.url,
rownum as rn
from
r_resultnews a
left join
v_chn_news b
on a.dataid=b.dataid
where
a.classid=2378
and siteid in (
select
siteid
from
tg_eventstatic
where
datatype=1
and eventclass=2378
and positionid='北京'
)
and rownum>0
)
where
rn>0
and rn<=30
SELECT *
FROM (SELECT A.RESULTID,
A.DATAID,
A.TIPTEXT,
B.TITLE,
B.CONTENT,
B.ISSUETIME,
B.URL,
ROWNUM AS RN
FROM R_RESULTNEWS A
LEFT JOIN V_CHN_NEWS B
ON A.DATAID = B.DATAID
WHERE A.CLASSID = 2378
AND EXISTS(SELECT 1 FROM TG_EVENTSTATIC c
WHERE a.SITEID=c.SITEID
AND DATATYPE = 1
AND EVENTCLASS = 2378
AND POSITIONID = '北京')
AND ROWNUM > 0)
WHERE RN > 0
AND RN <= 30