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

What is the string concatenation operator in oracle?

570

What is recovery manager(rman) backup in Oracle?

629

What is a package in oracle?

566

What are oracle functions?

553

Explain oracle 12c new features for developers?

540

How remove data files before opening a database?

564

What are internal user account in oracle?

571

Give the various rollback segment states.

579

what is Single Byte Overhead...?

2064

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1702

How to load excel data sheet to oracle database

588

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

556

How to count duplicated values in a column in oracle?

554

What is the oracle implicit cursor?

596

How to rollback the current transaction in oracle?

538