ANS : select max(ename) keep (dense_rank last order by sal) ename from e

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

Question Posted / girija.112

Answer Posted / girija.112

ANS :
select max(ename) keep (dense_rank last order by sal) ename
from emp

ENAME
-----
KING

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to use subqueries with the in operator using oracle?

1070

How to invoke the data pump import utility?

1143

What is materialized view in Oracle?

1059

What the is the diff between local index and global index. give some example.

1616

what is the difference between functional dependecy and multilevel dependency?

2445

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1070

What is an anonymous block?

1218

How to define a procedure inside another procedure?

999

Is it possible to split the print reviewer into more than one region ?

2259

What are the tools for Oracle ?

1041

How to start instance with a minimal initialization parameter file?

1024

How to build data dictionary view an new database?

989

What is the quickest way to export a table to a flat file?

952

How to join two tables in a single query using oracle?

970

how to join query for one source type is oracle another source type is sql server ?

2406