Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24093 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
What is the use of keyword with encryption. Create a store procedure with encryption?
What are acid properties of transaction?
what is hash nonclustered index
Is it possible to replicate data from sql server to oracle? : sql server replication
What is report subscription?
Is truncate autocommit?
What is the xml datatype?
Describe in brief sql server monitoring ways.
What is the importance of a recovery model?
How can we determine what objects a user-defined function depends upon?
How to create a scrollable cursor with the scroll option?
How to join two tables in a single query in ms sql server?
Explain comment on transactions?
How to set a database state to offline in ms sql server?
What is a non-clustered index?
