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

What have included columns when we talk about sql server indexing?

1005

How to list all schemas in a database?

1017

What are the different sql server versions?

943

Explain the benefits of user-defined functions?

1004

Tell me in brief how sql server enhances scalability of the database system?

950

What is report snapshot in ssrs?

254

How to generate random numbers with the rand() function in ms sql server?

1074

How to create percentile function?

142

How do I setup a local sql server database?

962

Does sql server 2000 clustering support load balancing?

922

When I run the sql server 2000 setup, it just hangs. What do I do?

1031

When does a workload on SQL Azure get throttled?

129

Explain Normalization and DE normalization

1064

Explain error and transaction handling in sql server?

966

What is checkpoint in sql server?

1079