SELECT ENAME,SAL FROM EMP WHERE ROWNUM = 1 ORDER BY SAL DESC

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

Question Posted / rohit

Answer Posted / rohit

SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How to revoke create session privilege from a user in oracle?

962

What happens if variable names collide with table/column names?

1104

What is a package ? What are the advantages of package ?

1033

How to get execution path reports on query statements?

929

List out the types of joins.

1083

What is the relation of a user account and a schema in oracle?

1007

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1010

How to display row numbers with the records?

1025

What is an oracle wallet?

882

How to count groups returned with the group by clause in oracle?

1012

Where are the settings stored for each instance in oracle?

1063

How to select some columns from a table in oracle?

1005

What is system tablespace?

1044

What is difference between truncate and delete?

977

What happens if recursive calls get out of control?

1000