Percentage Question

[lyric0n]

I have listed data in a table and need to find the percentage of each occurance, so similar to a count, but instead of returning the total count, I need a percentage of the total.

So...

Column
Type1
Type1
Type2
Type3

I need to have it return data in the form...
Name | Percent
Type1 | 50.00
Type2 | 25.00
Type3 | 25.00

I do also need 2 decimals in my remainder has I will have some small percentages.

Thanks,
Chris

 

[gmmastros]

Select 	[!]Column[/!], Convert(Decimal(10,2), 1.0 * Count([!]Column[/!]) / (Select Count([!]Column[/!]) From [!]Table[/!])) As Percentage
From 	[!]Table[/!]
Group By [!]Column[/!]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[lyric0n]

I was able to come up with a solution through this thread, thanks.

http://www.tek-tips.com/viewthread.cfm?qid=1330035&page=6