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 an oracle wallet?

504

What are data pump export and import modes?

602

Does facebook use oracle?

560

Give syntax for SQL and ORACLE joins.

624

How to use existing values in update statements using oracle?

540

How to call a stored function with parameters?

555

What are nested tables?

663

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

581

What is instant client oracle?

533

What is the Tune Query

1835

What exactly do quotation marks around the table name do?

538

What is oracle sid?

505

How to use in conditions in oracle?

546

How to create an oracle testing table?

584

Is the After report trigger fired if the report execution fails ?

2396