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

Explain rename?

976

What are the differences between lov and list item?

1063

Can a formula column be obtained through a select statement ?

2321

How to test null values?

1103

Explain oracle 12c new features for developers?

1058

What is user managed backup in Oracle?

1138

What is a select query statement in oracle?

963

What is the difference between a hot backup and a cold backup in oracle?

1014

Difference between inner join vs where ?

1033

Differentiate between translate and replace?

1116

What happens if you set the sga too low in oracle?

1143

How many types of segments in Oracle?

1070

Point the difference between translate and replace?

1083

What is Undo Management Advisor in Oracle?

1095

What are temporal data types in oracle?

1121