To find second largest salary in Employee table
Answer Posted / amit
select max(salary) from employee where salary != (select max
(salary) from employee)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is transaction server isolation?
What are the difference between “where” and “having” clause in sql server?
Are semicolons required at the end of sql statements in sql server 2005?
What are the fixed server level roles? : sql server security
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is “asynchronous” communication in sql server service broker?
What does it mean to normalize data?
Explain about temporary stored procedure?
List the types of recovery model available in sql server?
Define self join?
How to use “drop” keyword in sql server and give an example?
How to insert multiple rows with a subquery?
What are the triggers in sql?
How you can find out if an index is useful to the optimizer?
what are the three command line utilities and what are their primary functions?