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  ...
olafhelper's avatar
olafhelper
Bronze Contributor
May 03, 2023
You post is not very clear. What's the expect result; by that less sample data it's difficult to guess?
  • 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.

    • Srinivasnadimpalli0816's avatar
      Srinivasnadimpalli0816
      Copper Contributor
      May 04, 2023
      Can you please share the output based on input data. So that we can get better undedstand

Resources