Forum Discussion
ArarA911
May 03, 2023Copper Contributor
max count
dears, good day!! i have the below table date customer number branch transaction number 1/1/2020 1020 501 ...
olafhelper
May 03, 2023Bronze Contributor
You post is not very clear. What's the expect result; by that less sample data it's difficult to guess?
ArarA911
May 04, 2023Copper Contributor
hi olafhelper,
results would be
customer number highest transaction count in which branch transaction number count
hope you understand
results would be
customer number highest transaction count in which branch transaction number count
hope you understand
- olafhelperMay 04, 2023Bronze Contributor
hope you understand
ArarA911 , in no way.
Please post table design as DDL, some sample data as DML statement and the expected result.
- Srinivasnadimpalli0816May 04, 2023Copper ContributorCan you please share the output based on input data. So that we can get better undedstand