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

Difference between cartesian join and cross join?

1093

What is oracle rownum?

1016

How to use fetch statement in a loop?

1067

What is the recommended interval at which to run statspack snapshots, and why?

2963

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2250

What is define in oracle?

1111

How to establish administrator authentication to the server?

1096

How to use subqueries with the in operator using oracle?

1138

what's query optimization and without use of IN AND Exist can we get another way data from query

2200

How to define an explicit cursor in oracle?

1100

How to create a table interactively?

1166

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

What are ddl statements in oracle?

1128

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4571

Can we call procedure inside function in oracle?

1149