To find second largest salary in Employee table
Answer Posted / saravanakumar
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
what is spatial nonclustered index
Which sql server is best?
What is 'Join' and explain its various types.
What is explicit mode in sql server?
Write a query to find 5th highest amount paid from the customer table.
What happens to a trigger with multiple affected rows?
Why use cursor in sql server?
What is the purpose of the model database?
What is the use of builtinadministrators group in sql server? : sql server security
How do I find the sql server database version?
What are the disadvantages of primary key and foreign key in SQL?
What is the default port for SQL Server over a firewall?
What is code near application topology?
How fixed length strings are truncated and padded?
How do you debug a procedure in sql server?