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

Explain a synonym?

1032

Explain what does a control file contain?

1099

How to open a cursor variable?

1039

How do I know if oracle is installed on windows?

931

How to retrieve data from an explicit cursor?

1060

How do you find current date and time in oracle?

1047

What happens if you use a wrong connect identifier?

1066

How to select some columns from a table in oracle?

1096

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1350

What is columnar storage what is the advantage?

1064

Explain oracle instance.

1180

What are the various types of snapshots ?

1029

How to recover a dropped table in oracle?

1048

How to do clean up if create database failed?

1029

How to define a cusotmer as a supplier in ORACLE R12

2232