SELECT LEVEL, MAX(Sal) FROM Emp GROUP BY LEVEL HAVING LEVEL = &GiveN

how to findout the 100th maximum salary

Question Posted / swastik

Answer Posted / swastik

SELECT LEVEL, MAX(Sal)
FROM Emp
GROUP BY LEVEL
HAVING LEVEL = &GiveNo
CONNECT BY PRIOR Sal > Sal;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is union, minus and interact commands?

1213

what is data integrity? : Sql dba

986

What is a constraint? Tell me about its various levels.

1082

What are the usages of sql?

1011

what is dbms? : Sql dba

932

Does sql backup shrink transaction log?

914

What is the usage of the distinct keyword?

1167

Why query optimization is needed?

862

Is truncate ddl or dml?

943

Does sql view stored data?

898

Are sql connections encrypted?

955

What is normalization in a database?

1105

How much does sql cost?

930

What are different categories of sql commands?

1068

how mysql optimizes distinct? : Sql dba

1000