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

What is data manipulation language?

1232

The select into statement is most often used to create backup copies of tables or for archiving records?

1115

What is raw datatype in sql?

1106

what is isam? : Sql dba

1066

Why left join is used in sql?

1019

What is serial sql?

1040

How do I find duplicates in sql?

982

What is bulk compiling in pl/sql.?

1191

What is sql basics?

1083

Is sql a scripting language?

1086

What do you mean by stored procedures? How do we use it?

1039

What are hotfixes and patches?

986

How does index help in query performance?

1089

How do I create a sql script?

1142

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3110