how to check the 3rd max salary from an employee table?
Answer Posted / somanath
select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)
Is This Answer Correct ? | 34 Yes | 7 No |
Post New Answer View All Answers
difference between anonymous blocks and sub-programs.
what is the difference between blob and text? : Sql dba
What is an oracle stored procedure?
Do ddl statements need commit?
Which is the correct statement about truncate and delete?
What is left join in sql?
How to get each name only once from an employee table?
What does (+) mean in sql joins?
When to use inner join and left join?
What is the best free sql database?
What does pl sql stand for?
How do you go back in sql?
How to download oracle sql developer?
What are different types of sql commands?
Explain the the update statement in sql?