select * from emp where sal in(select max(sal) from emp where level=&am

how to findout the 100th maximum salary

Question Posted / ram

Answer Posted / ram

select * from emp
where sal in(select max(sal) from emp
where level=&nth
connect by prior sal>sal
group by level)order by sal

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you have a foreign key without a primary key?

955

What is oracle sql called?

923

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

Does pl/sql support create command?

1111

What is count * in sql?

1000

Why do we use function in pl sql?

1065

What is bulk compiling in pl/sql.?

1131

when MSQL8.0 is in market

2078

How many row comparison operators are used while working with a subquery?

1030

What sql does db2 use?

983

What is the non-clustered index in sql?

1064

What is informix sql?

980

What is the difference between a database and a relational database?

1103

What is a sql schema used for?

1105

What is sql and its types?

1192