srinivas medagum


{ City } hyd
< Country > india
* Profession *
User No # 38729
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 # 1
Users Marked my Answers as Wrong # 1
Questions / { srinivas medagum }
Questions Answers Category Views Company eMail




Answers / { srinivas medagum }

Question { 9329 }

How to retrieve 5th highest sal from emp table?


Answer

select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);

Is This Answer Correct ?    1 Yes 1 No