write the query for find the top 2 highest salary in sql
server
Answer Posted / krishna
select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)
Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
is there a column to which a default can't be bound? : Sql server database administration
What is inline table-value user-defined function?
How to resolve the orphan use problem? : sql server security
What are the steps you should follow to start sql server in single-user mode?
What is function of ROLLUP ?
What is oltp (online transaction processing)?
What is sql server locking?
What are the advantages of mirroring?
What is reportserver and reportservertempdb ?
What are the differences between substr and charindex in sql server.
Do you know what is difference between stored procedure and user defined function?
How to view existing indexes on an given table using sp_help?
How many types of subqueries are there in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What are the ways available in sql server to execute sql statements?