select ename,max(sal)from emp group by ename;

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

Question Posted / atal patra

15 Answers
15457 Views
I also Faced
E-Mail Answers

Answer Posted / atal patra

select ename,max(sal)from emp group by ename;

Is This Answer Correct ?

6 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is connection pool in oracle?

930

How to write numeric literals in oracle?

1128

How can you merge two tables in oracle?

939

What is varray?

1036

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1697

What is a subquery in oracle?

1043

What is index in Oracle?

1014

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

What are the general rules on data consistency?

960

How will you differentiate between varchar & varchar2?

992

How to convert a string to a date in oracle database?

1002

What is hash cluster in oracle?

1091

What is the Tune Query

2235

How many types of cluster table in Oracle?

987

What language does oracle use?

1049