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

How to synchronize 2 schema's objects?

2190

Why do we need oracle client?

966

Point out the difference between user tables and data dictionary?

991

What is the string concatenation operator in oracle?

1184

What are the types of partitions in oracle?

1043

how do u setup a replication site?

1998

How to resolve the ORA-39133 error in Oracle?

1131

What is different types of joins?

1029

Â How to use an oracle sequence generator in a mapping?

1083

How to build data dictionary view an new database?

1018

Explain temporal data types in oracle

1100

What do you mean by redo log file mirroring?

1042

How do you find current date and time in oracle?

1062

How to insert a new row into a table in oracle?

1174

Explain what are the advantages of views?

1074