3rd highest salary: select max(sal) from emp where sal

find out the third highest salary?

Question Posted / santanu

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

Please Help Members By Posting Answers For Below Questions

What is null value in oracle?

1100

What do you mean by redo log file mirroring?

1041

What is hash cluster in oracle?

1180

How to list all indexes in your schema?

1100

How to use group functions in the select clause using oracle?

1078

What is materialized view in Oracle?

1078

What is the simplest tool to run commands on oracle servers?

1014

Name the three major set of files on disk that compose a database in Oracle?

1127

How to export your connection information to a file?

1140

How to create a stored program unit?

1235

Is oracle the best database?

972

Explain the dml?

991

Is oracle a relational database?

924

What are the built-in functions used for sending Parameters to forms ?

3392

What is a server parameter file in oracle?

1063