SELECT * FROM (SELECT B .sequence# , B.FIRST_TIME,A. FIRST_TIME LAST_TIME,ROUND((A.FIRST_TIME -B .FIRST_TIME)*24*60,2) MINATES FROM V$LOG_HISTORY A,V$LOG_HISTORY B
WHERE A. RECID =B . RECID+ 1 ORDER BY A. FIRST_TIME DESC)WHERE ROWNUM <120
WHERE A. RECID =B . RECID+ 1 ORDER BY A. FIRST_TIME DESC)WHERE ROWNUM <120