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

What command is used to delete a table from the database in the sql server and how?

1041

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

971

Explain Geography datatype in SQL Server

1059

Name the different type of indexes in sql?

906

How to create user defined functions with parameters?

1163

What is the purpose of self join?

914

What are data files?

982

What happens if you are trying to access a schema not owned by you?

911

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1078

How do you use a subquery to find records that exist in one table and do not exist in another?

991

What programming language would you use to create embedded functions in ssrs?

172

Explain having clause and where clause?

989

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1040

What are the different types of cursor?

1039

What is the current pricing model of SQL Azure?

104