Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24397 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
Write a SQL query to make a column as unique?
What is @@rowcount in sql?
What command must you use to include the not null constraint after a table has already been created?
Data table as parameter in sql server?
Do you know data definition language, data control language and data manipulation language?
What are the properties of sub-query?
What are different type of Collation Sensitivity?
What is an inner join?
Name the different type of indexes in sql?
what is bit datatype? : Sql server database administration
What is the purpose of a table?
What is faster join or union?
What is 3nf normalization?
How can I track the changes or identify the latest insert-update-delete from a table?
How to list all objects in a given schema?
