how to use sql count function and group by.

Question

I have table that is given below. I want to get result show on top.
Table number 1st is output and table 2 is question.

Zone Name	Area
1	3
2	1
3	2
4	3
5	1
6	1

Zone Name	Area
1	A1
1	A2
1	A3
2	A4
3	A5
3	A6
4	A7
5	A8
6	A9
4	A10
4	A11

kalu singh rao · Answer

Thanx for all of you for give your valuable time for me.

Pradip Pandey · Answer

SELECT ZoneNameCOUNT(area) AS Area FROM TableName GROUP BY ZoneName Hope this will help you.

Munesh Sharma · Answer

select Zonename  count ( Zonename ) from table group by Zonename

Nilesh Dhande · Answer

i hope following query help select COUNT(ZoneName) as AreaZoneName from Areass group by ZoneName

Jignesh Trivedi · Answer

hi try Create table #table1 ( ZoneName int Area varchar(20) ) Insert into #table1 values(1'A1') (1'A2') (1'A3') (2'A4') (3'A5') (3'A6') (4'A7') (5'A8') (6'A9') (4'A10') (4'A11') select ZoneName COUNT(1) as area from #table1 group by ZoneName hope this will help you.