sql中根据网页的发布日期倒序后 获取前1000条记录

虾米链接: http://2814704901.iteye.com/blog/1934570

SELECT * FROM (

SELECT TT.title_result,

       TT.link,

       TT.content,

-------ROWNUM 表示行数  

       TT.add_name,AA,ROWNUM RA FROM (

select r.title_result,

       r.link,

       r.content,

       c.add_name,

       to_char(r.release_date, 'YYYY-MM-DD') AA

 

  from tb_yqcj_resultinfo r, tb_yqcj_address c

 where r.description = c.add_id

   and r.ri_id in

       (select t.rid

          from (select distinct r.title_result, max(r.ri_id) as rid

                  from tb_yqcj_resultinfo r

                 group by r.title_result) t)

 order by r.release_date desc) TT) WHERE RA<=1000