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

write the query for find the top 2 highest salary in sql
server

Question Posted / girish

Answer Posted / girish

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is SQL Azure Firewall?

136

What is row_number function?

960

What is a trigger and its types?

943

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

897

How many columns can we include on clustered index ?

952

How do you handle datasets larger than 50 gb?

162

What is difference between getdate and sysdatetime in sql server 2008?

1017

List all the types of user-defined functions?

1024

What triggers long term care?

1003

Can a synonym name of a table be used instead of a table name in a select statement?

988

What are the system database in sql server 2005?

1004

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1045

Can you explain the disadvantages/limitation of the cursor?

935

Explain what is lock escalation?

1016

Explain about SQL server 2005?

935