find out the third highest salary?
Answer Posted / santanu
3rd highest salary:
select max(sal) from emp
where sal < (select max(sal) from emp
where sal < (select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is null value in oracle?
What do you mean by redo log file mirroring?
What is hash cluster in oracle?
How to list all indexes in your schema?
How to use group functions in the select clause using oracle?
What is materialized view in Oracle?
What is the simplest tool to run commands on oracle servers?
Name the three major set of files on disk that compose a database in Oracle?
How to export your connection information to a file?
How to create a stored program unit?
Is oracle the best database?
Explain the dml?
Is oracle a relational database?
What are the built-in functions used for sending Parameters to forms ?
What is a server parameter file in oracle?