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 user defined stored procedures?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the difference between cartesian product and cross join?
What is database dimension? : sql server analysis services, ssas
How to bind a view to the schema of the underlying tables?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Explain the types of indexes.
What is sql server profiler?
Differentiate between a primary key and a unique key.
What is bit data type?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is the main purpose of having conversation group?
What is report snapshot?
Write an SQL query to obtain the 2nd highest salary.
What is create statement?