select ename,sal from emp E where 1=(select count(*) from emp where E.sal&

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

Question Posted / sivashankar.soma

Answer Posted / sivashankar.soma

select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)

Is This Answer Correct ?

16 Yes

29 No

Please Help Members By Posting Answers For Below Questions

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1099

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

977

What is the maximum size of column in sql server?

889

How does using a separate hard drive for several database objects improves performance right away?

927

How to get a list of all tables with "sys.tables" view in ms sql server?

1032

what are the disadvantages of cursors? : Sql server database administration

1029

What are the advantages of using a stored procedure?

1003

What are commonly used mssql functions in php?

1073

What is a non equi join?

979

How to create and drop temp table in sql server?

1049

Can an entity have two primary keys?

979

What do you mean by an execution plan? How would you view it?

912

What are the system database in sql server 2005?

1040

How to send a ssrs report from ssis?

176

explain how to create a new schema in a database? : Sql server database administration

1106