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
What is a result set object returned by mssql_query()?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is a linked server in sql server?
How to enter unicode character string literals in ms sql server?
Does the unique constraint create an index?
How to create an multi-statement table-valued function?
What is @@error in sql?
What is the default Port No on which SQL Server listens?
What is the difference between Stored Procedures and triggers?
What is inline table-value user-defined function?
How can we improve performance by using SQL Server profiler?
What are indexers?
When do you think a developer should use sql server-based cursors?
How to display a past time in days, hours and minutes?
How to convert character strings into numeric values?