Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24071 Views
- I also Faced
- E-Mail Answers
Answer Posted / maheswar reddy s
select * from Employee e1 where 6=(select count(distinct(salary))from employee e2 where
e2.salary>=e1.salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I view a script in sql server?
How do I find sql server instance name?
What is the difference between varchar and varchar types?
How secure is sql server database?
Write a sql query to sort on different column name according to the parameters passed in the function?
Can You Use Data Mining Models In Ssrs?
What is a dataset and what are the different types of datasets?
Can a database be shrunk with users active?
What are the properties of the relational tables?
What is the stuff?
What is scalar user-defined function?
What is the difference between upgrade and migration in sql server?
Do you know what is fill factor and pad index?
What is rs.exe utility?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
