select ename from employee where sal=(select disinct(max(sal) from employee

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

Question Posted / rushi

Answer Posted / rushi

select ename from employee where sal=(select disinct(max(sal) from employee));

Is This Answer Correct ?

2 Yes

8 No

Please Help Members By Posting Answers For Below Questions

why dont we assign not null constraint as table level constraint.

2256

How to start a new transaction in oracle?

593

What is a trigger oracle?

565

Does facebook use oracle?

577

What is data type in oracle?

566

What is the disadvantage of User defind function?

1833

What is a oracle database?

609

How to open a cursor variable?

611

What is ASM (Automatic Storage Management) in Oracle?

714

How to get a create statement for an existing table?

572

Explain oracle instance.

686

What is not equal to in oracle?

528

How to turn on or off recycle bin for the instance?

611

Explain parameter file in oracle.

580

What is oracle database client?

557