subash


{ City } delhi
< Country > india
* Profession * php programmer
User No # 24860
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 3
Questions / { subash }
Questions Answers Category Views Company eMail




Answers / { subash }

Question { Yardi, 321388 }

how to find the second highest salary from emp table?


Answer

SELECT salary
FROM employee e
WHERE n = (
SELECT count( * )
FROM employee
WHERE salary > e.salary )

n=1 or 2 or 3 n is level which level max salary you want
i test this it proper work

Is This Answer Correct ?    4 Yes 3 No