write the query for find the top 2 highest salary in sql
server

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


Please Help Members By Posting Answers For Below Questions

How to write an inner join with the where clause in ms sql server?

563


How to connect Azure federated root database and apply federation in entity framework?

87


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1763


Define full outer join in sql server joins?

508


What are different types of collation sensitivity?

544






How many types of attribute relationships are there? : sql server analysis services, ssas

592


Other than truncate statement, which other command can by-pass the trigger on the tables?

624


Where is localdb stored?

574


What is the purpose of linked server configuration in sql server?

567


What is the primary use of the model database?

634


How do you migrate data from mssql server to azure?

151


How to create “dependant” parameter “make, model, year”

91


Can we add a cpu to sql server?

530


Explain optimistic and pessimistic concurrency?

548


Is mysql the same as sql server?

517