write the query for find the top 2 highest salary in sql
server
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 |
Post New Answer View All Answers
Where can you find the error log information? : sql server database administration
Determine how to use the inserted and deleted pseudo tables?
What is your recommendation for a query running very slow? : sql server database administration
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is the index requirement in SQL Azure?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What happens if time-only values are provided as date and time literals?
how to define testing of network layers? : Sql server database administration
how to trace the traffic hitting a sql server? : Sql server database administration
What is linked report?
Where actually sql azure database is hosted?
Difference between Inner vs outer joins?
How many types of the database links?
What is the use of nvl work?
How to create a new schema in a database?