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 a system tablespace?

1134

What is recovery manager(rman) backup in Oracle?

1231

Briefly explain what is literal? Give an example where it can be used?

1088

How to use null as conditions in oracle?

1126

Write a syntax for update query in oracle?

1074

What happens if variable names collide with table/column names?

1265

How do I learn what codesets are available in oracle?

1078

what are actual and formal parameters?

1159

What is the relation of a user account and a schema?

1174

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1031

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

1170

How do I start tns listener?

1096

How to start a new transaction in oracle?

1136

What privilege is needed for a user to query tables in another schema?

1031

What are the uses of a database trigger?

1036