How to make query using sqlserver

Question

i have to make query
My table structure is like this
towncodeNo               TownName 2023001                   M1 2023001                   M1 2031025                   Z1 2031025                   Z1 2031030                   Z1
Result should be
Townname      Total M1             1 Z1             2
Kindly help me to make query using SQLServer 05

mohammad qasim · Answer

I have solved
solution
select t.townname,count(distinct(t.towncode))as total  from town t group by t.townname

Jignesh Trivedi · Answer

Hi,
using Group by you can achive this.
Select TownName, COUNT(1) as Total from table
Group by towncodeNo ,TownName
hope this help.