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

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

Question Posted / vijayalaxmi m khot

Answer Posted / vijayalaxmi m khot

select max(sal) from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

If no size is defined while creating the database, what size will the database have?

996

What is Lock table in SQL?

1475

What is rtm version in sql server?

1057

What is t-sql script to take database offline – take database online.

1090

How to reaname table name without using sp_Rename in sql server..?

998

explain the storage models of olap? : Sql server database administration

967

Can the query output be sorted by multiple columns in ms sql server?

987

What are the export options of ssrs?

173

How to round a numeric value to a specific precision?

1076

explain different types of cursors? : Sql server database administration

1095

How to Check if table exists in sql server?

1144

What is the dbcc command and why is it used?

1057

How to generate create function script on an existing function?

1122

What are page splits? : SQL Server Architecture

995

Give an example of why you would want to denormalize a database

979