krishna kishore


{ City } hyd
< Country > india
* Profession *
User No # 9666
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 # 0
Questions / { krishna kishore }
Questions Answers Category Views Company eMail




Answers / { krishna kishore }

Question { Yardi, 322223 }

how to find the second highest salary from emp table?


Answer

select top 1 salary from emp where salary in
(select top 2 salary from emp order by salary desc)
order by salary

Is This Answer Correct ?    1 Yes 0 No