select b.ename from emp b,(select max(sal) k from emp) a where a.k=b.sal;

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

Question Posted / srinu.g

Answer Posted / srinu.g

select b.ename from emp b,(select max(sal) k from emp) a
where a.k=b.sal;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is recycle bin in Oracle?

1086

Can group functions be used in the order by clause in oracle?

939

Explain the use of grant option in exp command.

1006

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

1033

Which is faster join or subquery in oracle?

934

Explain oracle 12c new features for developers?

995

How to define and use table alias names in oracle?

885

How do I manually uninstall oracle client?

1025

Explain the use of online redo log files in oracle.

993

How different is ms access and oracle?

990

What operating systems are supported by oracle database 10g xe?

985

How to get maxsal , minsal, ename department wise in single query

1501

How to list all tables in your schema?

992

How to lock and unlock a user account in oracle?

1028

How to pass parameters to procedures in oracle?

997