Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 74008 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 is normalization? Describe its different types.
What gets stored inside msdb database?
What is the full meaning of dml?
Does index speed up select statements?
What is nolock?
How can you list all the table constraints in a database?
How you trouble shoot when any job fails
What are “phantom rows”?
What is the difference between a stored procedure and a user defined function?
Explain what is meant by replication of database?
what is denormalization? : Sql server database administration
Can you explain what are various ways to enhance the ssrs report?
What is the boxing and unboxing concept in .net?
How to create a testing table with test data in ms sql server?
What are the various editions of sql server 2017 that are available in the market?
