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

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

Question Posted / mk

Answer Posted / mk

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

Is This Answer Correct ?

4 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What are the most common interview questions on ETL Testing for experience?

1075

How to upsert (update or insert into a table)?

951

What is the difference between count (*), count (expression), count (distinct expression)?

964

Why do we use bulk collect in oracle?

1010

How to export data with a field delimiter?

970

When do I need to use a semicolon vs a slash in oracle sql?

1026

Can group functions be used in the order by clause in oracle?

939

What are the different types of partitions in oracle?

909

what is Single Byte Overhead...?

2498

Please explain drop constraint oracle?

1026

How to see the table columns used in an index?

958

What is a table index?

1012

How do you store pictures in a database?

949

Point the difference between translate and replace?

1025

What is a data dictionary and how can it be created?

1055