摘要:
之前的农行绩效考核系统中有个需求是求,前5条公告的记录,之前是这么去实现的。string strSql = "select col1,col2 from (select col1,col2,,row_number() over(order by t.INPUTTIME desc) rowindex from TB_NOTE t where t.NOTELEVEL=:2 and t.BRANCHID=:3) tmp where tmp.rowindex>0 and tmp.rowindex<=:1";就是利用之前分页的思想,想排一下序,然后取前几条。但是在orac 阅读全文