write the query for find the top 2 highest salary in sql
server
Answer Posted / ramu
select * from emp e where 2=(select count(sal) from emp
where e.sal<=sal)
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What is data modification?
What types of Joins are possible with Sql Server?
How to find out the list schema name and table name for the database?
What is database replication?
What is the purpose of update statistics and scope_identity() function?
What are the dmvs? : sql server database administration
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How do I create a trace in sql server?
How many full-text indexes can a table have?
What are the operating modes in which database mirroring runs?
What is abstracting periodical?
How to insert data with null values?
How to enforce security in sql server? : sql server security
What do we have to check in database testing?
What is a synonym for manipulation?