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 are extents allocated to a segment?
How to view the tablespaces in the current database?
What is oracle data type?
What is an oracle wallet?
How to download oracle database 10g xe?
How to list all user accounts in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain the use of compress option in exp command.
interview questions with answer for cts
How to drop an existing view in oracle?
What are the benefits of ordbms?
Explain the different normalization forms?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How remove data files before opening a database?
What is the use of file param in imp command?