display issues for computation.

[Sri2003]

I have a record set which diplays the results something like this.
columnA columnB
9 blah
1 blahblah
0 dsjf
1 blah
2 blah.

I am trying to compute this table and populate in my new table as
newcolumn - A newcolumn - counts newcolumn - percent
0 1
1 2
2 1
9 1
Total

[Sri2003]

newcolumn - A newcolumn - counts newcolumn - percent
0 1
1 2
2 1
9 1
Total will be 5 and the percentile column will be for 0 as 1/5 * 100 like this.
Help plz..

[Anglo Saxon]

I am not sure if I understand exactly what you want try this :

SELECT colA,COUNT(colA) as number,perc=(CAST((COUNT(colA)*100) as float)/(SELECT COUNT(id) FROM tableA))
FROM tableA
GROUP BY colA

This will give you :
colA,number,perc
0, 1, 20.0
1, 2, 40.0
2, 1, 20.0
9, 1, 20.0

Is this what you want?

--
Anglo Saxon

[Sri2003]

I think this should work. Let me try this query - will get back in 10 mins.
Thanks a lot..