Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24095 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravakumar
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary
| Is This Answer Correct ? | 30 Yes | 8 No |
Post New Answer View All Answers
Can you force a query to use a specific index?
What is the difference between resultset and resultsetmetadata?
What is the difference between upgrade and migration in sql server?
How will you decide the active and passive nodes?
Tell me what is the significance of null value and why should we avoid permitting null values?
how many bits ip address consist of? : Sql server database administration
what is dbcc? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to find related tables in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How many columns can we include on clustered index ?
What are the advantages of user-defined functions over stored procedures in sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is a join in sql? What are the types of joins?
what is the difference between delete table and truncate table commands? : Sql server database administration
