how to solve this issue for count

Posted by Jayakumars under ASP.NET on 4/26/2012 | Points: 10 | Views : 599 | Status : [Member] [MVP] | Replies : 1
hi

i need how to count value for this my table like this users entry data will entry users some time different data

Id Items
1 AA
2 BB
3 CC
4 DD
5 EE
6 FF
7 Male
8 Female
9 Male
10 Female
11 VB.net
12 Asp.net

but i need output like this

I need Count Details like this

AA BB CC DD EE FF Male Female Vb.net Asp.net
1 1 1 1 1 2 2 2 1 1

Mark as Answer if its helpful to you


Responses

Posted by: Ajayk3 on: 4/26/2012 [Member] Starter | Points: 25

Up
0
Down
select items,count(Items) From table group by items

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response