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 the new security features added in sql server 2016? : sql server security

1116

How to create a simple stored procedure in ms sql server?

1027

Explain data warehousing in sql server?

1049

How many types of built in functions are there in sql server 2012?

926

What is difference between rollback immediate and with no_wait during alter database?

1090

How can we check the sql server version?

1067

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

982

Tell me what do we need queues in sql service broker?

993

What do you mean by data manipulation language?

1018

What are parameterized reports? What are cascading parameters in ssrs reports?

156

What is the difference between writing data to mirrored drives versus raid5 drives

932

Find nth lowest salary or get nth lowest salary?

1029

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

Explain what is dbcc?

1010

what is sql server? : Sql server database administration

987