Forum Discussion

ArarA911's avatar
ArarA911
Copper Contributor
May 03, 2023

max count

dears, good day!!    i have the below table    date                    customer number            branch        transaction number 1/1/2020                      1020                       501  ...
ArarA911's avatar
ArarA911
Copper Contributor
May 04, 2023
hi olafhelper,
results would be
customer number highest transaction count in which branch transaction number count

hope you understand
olafhelper's avatar
olafhelper
Bronze Contributor
May 04, 2023
hope you understand

ArarA911 , in no way.

Please post table design as DDL, some sample data as DML statement and the expected result.

Resources