Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 24096 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul gupta
select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a trace frag?
How do I clean up sql server transaction log?
how to create “alternate row colour”?
What is the difference between varchar and nvarchar?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain about remote stored procedure?
What are clustered and non-clustered index?
Explain triggers?
How to create new databases with "create database" statements?
what are database files and filegroups? : Sql server database administration
Data table as parameter in sql server?
What is sql server management studio? : sql server management studio
Define indexes?
What causes index fragmentation?
What is the boxing and unboxing concept in .net?
