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
- 72792 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
Explain the truncate command?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Why people hate cursor?
Explain about merge replications?
How to set database to be single_user in ms sql server?
What are partitioned views and distributed partitioned views?
What does it mean to invest in the index?
Does the unique constraint create an index?
What are logical database components? : SQL Server Architecture
How you can get a list of all the table constraints in a database? : Sql server administration
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is service broker? : sql server database administration
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
