sanjib banu


{ City } kolkata
< Country > india
* Profession * software engineer
User No # 74841
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 / { sanjib banu }
Questions Answers Category Views Company eMail




Answers / { sanjib banu }

Question { Qwest, 102937 }

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


Answer

select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))

Is This Answer Correct ?    1 Yes 0 No