find out the third highest salary?
Answer Posted / joel
select sal from emp
where sal<(select max(sal) from emp
where sal in (select sal from emp
where sal < ( select max(sal) from emp)))
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
How to end the current transaction in oracle?
Which is better Oracle or MS SQL? Why?
How to login to the server without an instance?
How to generate query output in html format?
Can we store images in oracle database?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to load excel data sheet to oracle database
What is a select query statement in oracle?
What is an oracle and why it is used?
What is open database communication (odbc) in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to define a record variable to store a table row?
What are the extensions used by oracle reports?
Differentiate between pre-select and pre-query?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?