write the query for find the top 2 highest salary in sql
server
Answer Posted / srinivas
select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)
| Is This Answer Correct ? | 33 Yes | 32 No |
Post New Answer View All Answers
What is the difference between value type and reference type?
Can we use having clause without group by?
How to create a simple table to test triggers in ms sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is index in an assignment?
How is sql server used?
Can a database be shrunk with users active?
What is db stored procedure?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to assign new column names in a view?
what is nonclustered index
New concepts of sql server 2005 use in your project.
Which is better statement or preparedstatement?
Can you tell me about the concept of ER diagrams?