towncodeNo TownName 2023001 M1 2023001 M1 2031025 Z1 2031025 Z1 2031030 Z1
Townname Total M1 1 Z1 2
SELECT TownName, COUNT(TownName) - 1 AS Total FROM myTable GROUP BY TownName
select TownName, Count(Distinct(towncodeNo )) from tblSample group by TownName;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)