Select * from (Select Rownum R, E. * from (select a. * from sys_user a order by a.work_no desc) E - SELECT ROWNUM R, B. * from Sys_User B
SS, SYS_DEPARTMENT B, SYS_TITLE C Wheress.dept_id = B.DEPT_ID ( ) and ss.title_id = c.title_id ( ) and ss.r> = 1 and ss.r <= 10 ORDER BY SS.WORK_NO DESC
For Conditional Oracle Patement
