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

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

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

Answers

How to make query using sqlserver

mohammad qasim

13y

1.9k

i have to make query

My table structure is like this

towncodeNo TownName

2023001 M1

2031025 Z1

2031030 Z1

Result should be

Townname Total

M1 1

Z1 2

Kindly help me to make query using SQLServer 05

Next Recommended Forum

Stored Procedure

BCP Error

Forum Statistics

Upcoming Events

View all