write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 69314 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / uday
select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)
i am sure that it should work.
Any thing wrong plz inform me
| Is This Answer Correct ? | 5 Yes | 9 No |
Post New Answer View All Answers
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is deploy, process and build? : sql server analysis services, ssas
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain difference between control flow and data flow?
What are different types of data sources?
What is a full text index?
What are the different SQL Server Versions you have worked on?
Explain indexing and what are the advantages of it?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Explain the different types of joins?
Difference between DELETE and TRUNCATE?
What method is used by the Command classes to execute SQL statements that return single values?
What are the joins in sql server? : sql server database administration
how many clustered indexes can be created on a table? : Sql server database administration
What is the recursive stored procedure in sql server?
