SELECT sal FROM emp e WHERE &100=(SELECT COUNT(DISTINCT(SAL))

how to findout the 100th maximum salary

Question Posted / g sivanagaraju

Answer Posted / g sivanagaraju

SELECT sal
FROM emp e
WHERE &100=(SELECT COUNT(DISTINCT(SAL))
FROM emp
WHERE e.sal<=sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why is theta join required?

1188

How many disk partitions should I have?

1040

Can we use loop in sql?

1010

How does a trigger work?

1144

What is the benefit of foreign key?

1069

how to create a test table in your mysql server? : Sql dba

1056

How do you remove duplicate records from a table?

981

How to create an array in pl/sql?

1122

Is the primary key an index?

1078

What does the hierarchical profiler does?

1126

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3623

what is transaction? : Sql dba

1061

Which table is left in join?

1017

How is use pl and sql?

1108

Is sql open source?

1025