这是我原来的sql:
String sql="select s.* from(select t.*,rownum n from (select id,msg_Title,msg_Sdate from Sys_Msg where status=? and msg_sdate<sysdate and msg_edate>sysdate order by sort_Num,msg_Sdate desc) t) s where s.n in (:num)";String sql="select s.* from(select