how to check the 3rd max salary from an employee table?
Answer Posted / nagendra
select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)
Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are the constraints available in sql?
How do you remove duplicates without using distinct in sql?
How to use sql statements in pl/sql?
What is the difference between the conventional and direct path loads? : aql loader
Why we use joins in sql?
What is t sql in sql server?
How to change the order of columns in Oracle SQL Plus ?
Can we use the cursor's to create the collection in PL/SQL?
What is orm in sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
What does (+) mean in sql joins?
Explain mutating table error.
What is a design view?
How do you know if a relationship is 2nf?
What are the usages of sql?