select Max(salery) from salery where salery IN( select top N salery fro

find out the third highest salary?

Question Posted / anish nama

Answer Posted / anish nama

select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the difference between substr & instr functions?

1228

How can we force the database to use the user specified rollback segment?

1148

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

How can I get column names from a table in oracle?

1048

What is the difference between truncate & delete command?

1183

What is the difference between $oracle_base and $oracle_home?

1089

When system tablespace is created?

1042

In what script is snap$ created? In what script is the scott/tiger schema created?

2709

Why is oracle used?

939

List out the components of logical database structure of oracle database.

1039

What is background process in Oracle?

1101

Explain the use of owner option in exp command.

1046

What are the uses of Database Trigger ?

1720

How to convert character types to numeric types?

1135

How to use "out" parameter properly?

1082