How to select the name of employee who is getting maximum
sal with out using subquery
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 |
Post New Answer View All Answers
Difference between oracle's plus (+) notation and ansi join notation?
What is a nested table?
What are the uses of Database Trigger ?
Difference between cartesian join and cross join?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is materialized view in Oracle?
How to get last row id?
What is key preserved table?
How to invoke the original export import utilities?
What are the different windows events activated at runtime ?
What is tns name?
How to rename an index?
What is a proxy class?
How to start an oracle instance?
what are the default admin accounts in Oracle 10g ?