SELECT * FROM Emp WHERE LEVEL=&Number CONNECT BY PRIOR Sal

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / naidu

Answer Posted / naidu

SELECT * FROM Emp
WHERE LEVEL=&Number
CONNECT BY PRIOR Sal > Sal ;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run the anonymous block again?

1110

What are the limitations of check constraint?

1012

What privilege is needed for a user to create views in oracle?

1023

State and explain about oracle instance?

977

What is the difference between count (*), count (expression), count (distinct expression)?

989

Explain compound trigger in oracle?

1019

How to check database size in Oracle?

1170

What are the differences between char and varchar2 in oracle?

1141

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1046

Why do you use stored procedures and state some of its disadvantages?

1011

What are the different types of trigger and explain its various uses and functions?

1065

How to insert a record into a table?

1054

Explain self joins in oracle?

994

How to use "while" statements in oracle?

1299

Explain alias?

1108