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

Answer Posted / atal patra

Is This Answer Correct ?

6 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is hash cluster in oracle?

1245

what are the default admin accounts in Oracle 10g ?

1022

Is oracle an operator?

983

What is the use of aggregate functions in oracle?

1071

Can we create trigger on materialized view in oracle?

1044

how can we store any pdf file in oracle

2220

How to lock and unlock a user account in oracle?

1161

How index is implemented in oracle database?

1045

What are the benefits of ordbms?

1137

Why does for update in oracle 8 cause an ora-01002 error?

1047

What happens if you use a wrong connect identifier?

1140

What do you mean by merge in oracle?

1029

What is oracle database client?

1081

Difference between varchar and varchar2 data types?

1262

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2178