mohammad qasim

mohammad qasim

  • NA
  • 408
  • 0

How to make query using sqlserver

Mar 27 2012 4:41 AM
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

Answers (2)