husenaiah


{ City } bangalore
< Country > india
* Profession * se
User No # 5193
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 # 22
Users Marked my Answers as Wrong # 38
Questions / { husenaiah }
Questions Answers Category Views Company eMail




Answers / { husenaiah }

Question { Hewitt, 128782 }

find out the third highest salary?


Answer

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

Is This Answer Correct ?    22 Yes 38 No