write the query for find the top 2 highest salary in sql
server
Answer Posted / mohan c v
select min(salary) from
(select top 2 salary from phani order by salary desc) as a
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to manipulate data from one table to another table ?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How do you identify a foreign key?
What are rest-style architecture's?
What are data driven subscriptions?
How to connect to SQL Azure Database by using sqlcmd?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is the default value of an integer data type in sql server 2005?
What number aggregate functions are accessible there in sql?
What is difference between drop truncate and delete?
what is nonclustered index
Can a synonym name of a table be used instead of a table name in a select statement?
Does the unique constraint create an index?
What is a DBMS, query, SQL?
Where are sql server usernames and passwords stored in the sql server?