find out the third highest salary?
Answer Posted / manoj
select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
definition of cluster and non-clustered index?
What is memory advisor in Oracle?
How can we force the database to use the user specified rollback segment?
Point out the difference between user tables and data dictionary?
What is instant client oracle?
How many types of cluster table in Oracle?
How to unlock the sample user account in oracle?
How can you use check constraints for self referential integrity?
How to change program global area (pga) in oracle?
various types of hints and their usage
Explain an exception and its types?
How can I combine multiple rows into a comma-delimited list in oracle?
How to bring a tablespace offline?
How to start your 10g xe server?