naresh


{ City } hyderabad
< Country > india
* Profession * software engineer
User No # 55772
Total Questions Posted # 1
Total Answers Posted # 1

Total Answers Posted for My Questions # 2
Total Views for My Questions # 4625

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { naresh }
Questions Answers Category Views Company eMail

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

 2 SQL PLSQL 4625



Answers / { naresh }

Question { Qwest, 106353 }

Write a query to get 2nd maximum salary in an employee table ?


Answer

select sal from emp e where 2= (select count(distntsal) from
emp y where e.sal<=y.sal);

Is This Answer Correct ?    1 Yes 0 No