Important. this isssue does NOT exist on sqlite as it accepts duplicate column names in the ORDER_BY sql query but SQL server does not and probably mysql or Mariadb will have this issue When sorting ...

Now we need to change all duplicate values to null. In other words, after grouping by the first two fields (or one of them), only the first record in the group remains unchanged, and the first two ...