please tell me the query to get details of the employee
having the second largest salary
Answer Posted / eswar
select max(salary) from emp
where salary<(select max(salary) from emp)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are clustered and non-clustered index?
Why do you want to join software field as you have done your BE in Electronics?
explain different types of constraints? : Sql server database administration
How do I create a trace in sql server?
What are number line correlation administrators will use while working with a subquery?
Is port 1433 secure?
How to deploy the Report?
What is the use of =,==,=== operators?
Is the primary key column of a table an index in ms sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Explain ranking functions?
Explain contrast amongst grouped and non-bunched records?
What do you understand by hotfixes and patches in sql server?
What is a field name?