write the query for find the top 2 highest salary in sql
server
Answer Posted / santhosh kumar
select Distinct Top 2 Salary from EMP order by Salary desc
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
How you can change a cross join into an inner join?
How to provide default values to function parameters?
What happens if ntwdblib.dll is missing on your machine?
How do I debug a stored procedure in sql server?
How would we use distinct statement? What is its use?
Write SQL queries on Self Join and Inner Join.
What is the sql profiler?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to execute a sql statement using mssql_query()?
What purpose does the model database server?
How to use transact-sql statements to access the database engine?
How to invoke a trigger on demand?
How to set database to be single_user in ms sql server?
What is the purpose of object explorer and its features? : sql server management studio
What is the process of indexing?