select max(sal) from emp where sal < (select max(sal) from emp where sal

find out the third highest salary?

Question Posted / ravindra

Answer Posted / ravindra

select max(sal) from emp where sal < (select max(sal) from emp where sal < (select max(sal) from emp));

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1153

How to speed up webrick?

1125

How to change program global area (pga) in oracle?

1148

Is there any function in oracle similar like group_concat of mysql?

1109

How to drop an existing view in oracle?

992

How to create lov dynamically at runtime & attach to text field?

1240

Which is better Oracle or MS SQL? Why?

6486

What are joins, explain all types of joins?

2364

Explain the difference between replace() and translate() functions in oracle?

1086

Is postgres faster than oracle?

1087

How to load data through external tables?

1190

How to revoke create session privilege from a user in oracle?

1069

How to shutdown your 10g xe server from command line?

1154

Is oracle a programming language?

1039

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

1171