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

Answer Posted / mk

select Name from emp where sal=(select distinct(Max(sal))
from emp

Is This Answer Correct ?    4 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

561


What is the difference between sharding and partitioning?

503


What is oracle in java?

524


What is Redo Log Buffer in Oracle?

634


How to call a sub procedure?

564






What do you understand by a database object? Can you list a few of them?

610


Can sub procedure/function be called recursively?

541


Explain the use of owner option in exp command.

569


How to retrieve data from an cursor to a record?

563


What are the different types of failures that occur in Oracle database?

605


Can you have more than one content canvas view attached with a window ?

1817


Is postgres faster than oracle?

561


How to define an explicit cursor in oracle?

603


What is difference between sid and service name in oracle?

519


What are the original export and import utilities?

571