QUERY TO SELECT 7TH HIGHEST RECORD FROM TABLE

SELECT * FROM USERS 
(
  SELECT * FROM USERS 
(
SELECT * FROM USERS 
(
SELECT * FROM USERS ORDER BY DESC  
) WHERE ROWNUM <=7
) ORDER BY ASC 
) WHERE ROWNUM = 7