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 "out" parameter properly?

1087

How to view the data files in the current database?

1103

What are a collation and state the different types of collation sensitivity?

1176

How to invoke the data pump export utility?

1198

How to select some columns from a table in oracle?

1100

What is oracle database client?

1038

What is oracle used for?

1030

How do I start tns listener?

1052

How to initialize variables with default values?

1251

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2005

How do I find my oracle client driver version?

1048

What is the scope of a local variable?

1073

What are named parameters?

1098

How to compare dates in oracle sql?

1111

Compare and contrast between sql and sql server and explain its various functions?

973