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
Is mysql the same as sql server?
Can we call future method from trigger?
Is sql server difficult to learn?
What is tabulation?
Is it safe to delete log files?
Explain an automatic checkpoint
How to maintain a fill factor in existing indexes?
What does null mean?
explain declarative management framework (dmf) in sql server 2008?
Can a function call a stored procedure in sql server?
Do you know query execution plan?
What are the dis_advantages of stored procedures, triggers, indexes?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Explain the stored procedure?
Define self join?