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
Determine when an index is appropriate?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can you explain what are commit and rollback in sql?
How can you stop stored procedures from recompiling?
What is the purpose of optimization?
What is multilevel indexing?
What are user-defined functions (udfs) in sql server?
What is the native system stored procedure to execute a command against all databases?
What is the stuff?
What causes index fragmentation?
Tell me the difference between clustered and non-clustered index?
What is a cursor, index in sql?
Can you explain full-text query in sql server?
Difference between DELETE and TRUNCATE?
How can a database be repaired?