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

Can we convert a date to char in oracle and if so, what would be the syntax?

1019

Can we insert data in view oracle?

1045

Name the three major set of files on disk that compose a database in Oracle?

1127

How to build data dictionary view an new database?

1015

What is ASM (Automatic Storage Management) in Oracle?

1199

What is a data lock in oracle?

1134

What happens in oracle commit?

1033

How to write text literals in oracle?

1071

How does the on-delete-cascade statement work?

1117

What is oracle database client?

1037

What exactly do quotation marks around the table name do?

966

How do you bind variables in oracle?

985

Explain the truncate in oracle?

971

How do I find the database name in oracle?

1042

What is raw datatype?

1145