Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GROUP BY with HAVING (MAX)

771196Aug 14 2010 — edited Aug 14 2010
The SELECT-instruction with the GROUP BY-clause shows the incomplete result.

The result of this query should show only the group of the car manufacturer who shows the maximum, middle hourly number (DFC).

How must the clause HAVING be here?



SELECT typ, AVG (c_h) DFC

GROUP BY typ

HAVING ?;


The result is:

TYP DFC
MG 5000
Jaguar 7000
Triumph 9000



Many thanks in advance for the help.

Edited by: user3227321 on 14.08.2010 11:55
This post has been answered by 780914 on Aug 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2010
Added on Aug 14 2010
3 comments
28,418 views