write the query for find the top 2 highest salary in sql
server
Answer Posted / ravi pahuja
selecl distinct top 2 salories from emp order by salory desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is stored procedures?
How can we check the sql server version?
When should you use an instead of trigger?
What are statistics?
What is transaction server explicit transaction?
How to modify existing triggers using "alter trigger"?
Explain having clause and where clause?
What is the use of custom fields in report?
How to drop an existing table with "drop table" statements in ms sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How do you improve the performance of a SQL Azure Database?
what is normalization? Explain different levels of normalization? : Sql server database administration
Explain the difference between function and stored procedure?
Tell me what are the advantages of using stored procedures?
Explain transaction isolation levels in sql server?