select min(sal) from empl where romwnum

how to findout the 100th maximum salary

Question Posted / raghuvir

Answer Posted / raghuvir

select min(sal) from empl where romwnum < = 100 order by
sal desc

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to take user input in pl sql?

1161

What is on delete restrict?

1000

What are the different tcl commands in sql?

1172

what is rollback? : Sql dba

1105

Where do we use pl sql?

993

What are the different type of joins in sql?

953

What are properties of the transaction?

998

what is the difference between group by and order by in sql? : Sql dba

1127

What are the types of join and explain each?

1034

What is partition in sql query?

998

How to connect a sql*plus session to an oracle server?

1122

What are schema-level triggers?

1100

Does sap use sql?

988

What is a pragma statement?

1262

What is the use of sqldataadapter?

967