please tell me the query to get details of the employee
having the second largest salary

Answer Posted / ss

select max(salary) from emp
where salary<(select max(salary) from emp)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to make a column nullable?

572


What is filestream?

537


What are the differences between union, intersect, and minus operators?

547


What are two difference between sql azure and azure tables?

135


What is self join in sql server joins?

536






Explain about nested stored procedure?

584


How to create a trigger for insert only?

571


What does top operator do?

546


What are character string data types in ms sql server?

609


Explain acid?

584


When columns are added to existing tables, what do they initially contain?

606


Why should we go for stored procedures? Why not direct queries?

555


Explain where clause?

514


Can coalesce return null?

517


How efficient you are in oracle and SQL server?

606