How to find 6th highest salary from Employee table ?

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


Please Help Members By Posting Answers For Below Questions

Is mysql the same as sql server?

517


Can we call future method from trigger?

520


Is sql server difficult to learn?

530


What is tabulation?

566


Is it safe to delete log files?

531






Explain an automatic checkpoint

573


How to maintain a fill factor in existing indexes?

535


What does null mean?

609


explain declarative management framework (dmf) in sql server 2008?

601


Can a function call a stored procedure in sql server?

537


Do you know query execution plan?

597


What are the dis_advantages of stored procedures, triggers, indexes?

1700


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

547


Explain the stored procedure?

645


Define self join?

635