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

Where can you find the error log information? : sql server database administration

1071

Determine how to use the inserted and deleted pseudo tables?

1042

What is your recommendation for a query running very slow? : sql server database administration

1110

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

What is the index requirement in SQL Azure?

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

What happens if time-only values are provided as date and time literals?

1057

how to define testing of network layers? : Sql server database administration

1020

how to trace the traffic hitting a sql server? : Sql server database administration

1949

What is linked report?

137

Where actually sql azure database is hosted?

165

Difference between Inner vs outer joins?

985

How many types of the database links?

1115

What is the use of nvl work?

1044

How to create a new schema in a database?

1206