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

Difference between open_form and call_form in oracle.

1112

What is snapshot is too old? Give and example for better understand.

1561

What is a parameter file in oracle?

1074

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2012

What are the different windows events activated at runtime ?

2855

What is the difference between a hot backup and a cold backup in oracle?

979

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

2240

What is the parameter mode that can be passed to a procedure?

1005

How can we create the complete backup of data in the oracle.

2111

What is sequence?

1038

How to Truncate Table in Oracle

1118

How to build data dictionary view an new database?

977

What is a connect identifier?

1006

How do I find the database name in oracle?

1002

What is raw datatype?

1094