ORACLE SQL语句总结

sql积累

---

• 分组分页sql

---

分组分页sql：

select * from(    select rownum AS ROWNO ,t1.* from(          select              t.id_card AS idCard,               t.name AS tName,               sum(t.comment_count) AS sumCommentCount           from               YQKZ_COMMENTER_TASK t           where               t.release_time >= to_date('2015-01-01','yyyy-MM-dd')          and               t.release_time <= to_date('2016-12-01','yyyy-MM-dd')          group by              t.id_card,             t.name) t1    where rownum <= 10) t2where t2.ROWNO >=0