select empname,sal from empdpt e where 1=(select count(*) from empdpt wher

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

Question Posted / karan

Answer Posted / karan

select empname,sal from empdpt e where 1=(select count(*) from
empdpt where e.sal<sal)

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to create a local temporary stored procedure?

998

How to stop a loop early with break statements in ms sql server?

1021

What is meant by referential integrity?

1011

what is the difference between delete table and truncate table commands? : Sql server database administration

1040

What is a with(nolock)?

984

Does sql server 2000 clustering support load balancing?

980

What is log shipping?

963

What are the requirements on sql server network connections?

1001

What is similarity and difference between truncate and delete in sql?

1102

How to disable triggers using "disable trigger"?

1058

How to copy data from one table to another table?

997

If a stored procedure is taking a table data type, how it looks?

6451

What number sorts of privileges are accessible in sql?

1037

How does index makes search faster?

979

Explain the relational database management system (rdbms)?

1101