一條好使好用既Oracle SQL

// get all user photo ,then,one user only select userMaxRecord photos
sql = " select * from ("+
"SELECT p.id,p.name,p.click_total,p.file_id,p.column_id,p.user_id,p.district_id,u.nickname,c.name as column_name "+
",row_number() over (partition by p.user_id "+ sqlOrder+") rnum "+
" FROM album_photo_t p left join album_column_t c on p.column_id=c.id left join user_t u on p.user_id = u.user_id"+
" WHERE p.record_state >=0 AND c.type_id="+AlbumDAO.TYPE_ID_ALBUM + " AND ";

sql += sqlPrivate;
sql += sqlOrder;
sql +=") where rnum <= "+userMaxRecord;

//另一條做reference
sql = " select a.QUEST_ID, a.NAME, a.TYPE, a.CAN_REPEAT, nvl(b.STATUS, 'NEW') as STATUS from ( "
+ " ( select * from QUEST_T where TYPE = ? ) a "
+ " left join "
+ " ( select * from "
+ " ( select QUEST_ID, USER_ID, STATUS, row_number() over (partition by QUEST_ID order by START_TIME desc) rnum from USER_QUEST_T where USER_ID = ? ) "
+ " where rnum <=1 ) b "
+ " on a.QUEST_ID = b.QUEST_ID ) order by QUEST_ID ";