Convert to% for SQL counter

Question

SELECT DEL_CD ,COUNT(DEL_CD) AS COUNT_NO
FROM [DATAStaging].[dbo].[DATASTORE]
GROUP BY DEL_CD

gives me this result

DEL_CD     COUNT_NO
0           6442
1           12161
2           2342

But what do I need to do for the script to display the account number as%

Total lines = sum of count_no.

Thanks in advance

+3

icecurtain Mar 22 '11 at 14:27

1 answer

Quassnoi · Accepted Answer · 2011-03-22T14:32:18+0000

SELECT   del_cd, COUNT(DEL_CD) * 100.0 / SUM(COUNT(DEL_CD)) OVER ()
FROM     datastore
GROUP BY
         del_cd