write the query for find the top 2 highest salary in sql
server
Answer Posted / sivashankar.soma
select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)
| Is This Answer Correct ? | 16 Yes | 29 No |
Post New Answer View All Answers
What is instead of dml trigger?
What is the significance of master, tempdb and model databases?
What is the maximum rows in sql server table?
What are the advantages of using third-party tools?
Differentiate between mongodb vs. Sql server?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can you leave a union at any time?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Explain what is public role in sql server?
How to enable/disable indexes?
How do I start sql server agent automatically?
What is sql collation?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is use of except clause? How does it differ from not in clause?