write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 69285 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / arun kumar k s
select Distinct Top 2 Salary from EMP order by Salary desc
| Is This Answer Correct ? | 111 Yes | 59 No |
Post New Answer View All Answers
What are the pre-defined functions in the sql server?
What do you understand by check constraint in sql server?
What is meant by indexing files?
How to use "begin ... End" statement structures in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Explain primary key and foreign key constraints?
Explain what are the basic functions for master, msdb, model, tempdb databases?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What does sql server mean?
What is data compression?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are the types of table?
What are the differences between stored procedure and the dynamic sql?
Explain database normalization?
How efficient you are in oracle and SQL server?
