Soumya Ranjan Pradhan

• May 13th, 2007

 

The right answer for this out put is
   

SELECT LEVEL, MAX(colname)
FROM tablename
WHERE LEVEL = &LevelNo
CONNECT BY PRIOR colname > colname
GROUP BY LEVEL
/


Ans------

SELECT LEVEL, MAX(Sal)
FROM Emp
WHERE LEVEL = &LevelNo
CONNECT BY PRIOR Sal > Sal
GROUP BY LEVEL
/

vaibhav Tyagi

• Sep 25th, 2007

 

select max([columnName]-4) from tableName

sunshine60india

 Profile Answers by sunshine60india 

• Jun 18th, 2011

 

SELECT TOP 1 * FROM
(
    SELECT TOP 4 * FROM EMPLOYEE ORDER BY CTC desc
)A
ORDER BY CTC

Shiyamala Devi

• Jan 5th, 2012

 

Code
 SELECT *


        FROM (SELECT player_nm, gross_sal,


               RANK () OVER (ORDER BY gross_sal DESC) playerRank


              FROM player)


        WHERE playerRank = 4;

This query will display 4th highest salary from the player table