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
- 74169 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / pari
select max(sal) from emp
where sal !=(select max(sal) from emp);
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are different types of views?
What is #table in sql server?
Explain comment on transactions?
Define candidate key, alternate key, and composite key.
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the steps to insert a table?
what is the difference between delete table and truncate table commands? : Sql server database administration
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is transact-sql ddl trigger?
What are the steps you will take to improve the performance of a poor performing query?
Can binary strings be used in arithmetical operations?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are orphan records?
What is the meaning of sql server?
What is DCL?
