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 sql comments?

1072

What are the types of triggers in sql?

1089

how to enter characters as hex numbers? : Sql dba

1038

What is sql partition function?

1202

How does an execution block start and end in pl sql?

950

Mention what are different methods to trace the pl/sql code?

1201

what is data manipulation language? : Sql dba

1012

How do I enable sql encryption?

1028

What is transaction control language (tcl)?

1134

What is mutating error?

965

What are the types of queries in sql?

1084

How to run pl sql program in mysql?

1017

How to place comments in pl/sql?

1154

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

Explain 3 basic parts of a trigger.

1317