Link to home
Start Free TrialLog in
Avatar of turaks
turaksFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Max in a group

Hello,

i am trying to report on max row in a group as an example,

class 2A has 3 students and each student takes 1 or more subjects. e.g James, john and Peter.  Peter takes 4 subjects and James 2 and John 3 . I need to return the student taking the highest number of subjects within that group which is Peter in this case.  Also class 2B has Sandy, Joan and Grace each taking 5, 4 and 3 subjects respectively.  Sandy is who I want to return from this group.

Overall I would like to return Sandy and Peter from each group.

Can someone help with this please?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Wim_Bl
Wim_Bl
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of turaks

ASKER

Hi,

thanks.  Surely a step in the right direction.  Still need to get my head round using the group by with rank.  Any examples would help.
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Question answered by https:#a38588820 and https:#a38589338