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

Describe an oracle table?

1049

How to establish administrator authentication to the server?

1043

Explain the use of online redo log files in oracle.

1038

What do you understand by a database object? Can you list a few of them?

1018

What are the types of trigger in oracle?

984

material view and view disadvantages?

1073

What are oracle functions?

1030

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

When system tablespace is created?

1042

State any two functions of oracle?

1046

What is object data modeling?

969

Design database draw er diagram for a certain scenario ?

4579

How to use "in out" parameter properly?

1048

What is an oracle and why it is used?

1150

How to start an oracle instance?

1019