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 are extents allocated to a segment?

575


How to view the tablespaces in the current database?

559


What is oracle data type?

555


What is an oracle wallet?

513


How to download oracle database 10g xe?

597






How to list all user accounts in oracle?

612


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1618


Explain the use of compress option in exp command.

548


interview questions with answer for cts

2088


How to drop an existing view in oracle?

568


What are the benefits of ordbms?

619


Explain the different normalization forms?

591


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

546


How remove data files before opening a database?

564


What is the use of file param in imp command?

644