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


Please Help Members By Posting Answers For Below Questions

How to grant create session privilege to a user in oracle?

574


definition of cluster and non-clustered index?

2482


What is memory advisor in Oracle?

642


How can we force the database to use the user specified rollback segment?

562


Point out the difference between user tables and data dictionary?

546






What is instant client oracle?

547


How many types of cluster table in Oracle?

581


How to unlock the sample user account in oracle?

559


How can you use check constraints for self referential integrity?

527


How to change program global area (pga) in oracle?

592


various types of hints and their usage

2135


Explain an exception and its types?

613


How can I combine multiple rows into a comma-delimited list in oracle?

584


How to bring a tablespace offline?

545


How to start your 10g xe server?

602