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

What is an Oracle Instance?

679

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1461

How can windows applications connect to oracle servers?

515

How can you merge two tables in oracle?

562

Why do we use coalesce function in oracle?

618

Give the different types of rollback segments.

569

Is postgres faster than oracle?

553

What is the difference between alert log file and tarce file ?

1628

What is logical backup in oracle?

569

Hi Can any one tell me what are the API's used in requisition import.

1478

What is a subquery?

607

What is difference between cartesian join and cross join?

580

What is an Oracle index?

1170

How to see free space of each tablespace?

585

What is columnar storage what is the advantage?

537