tag:blogger.com,1999:blog-495177919198719500.post4759203681099618105..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Calculate Percentage in SQL ServerSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-34043395016310465202010-12-21T22:53:45.790-08:002010-12-21T22:53:45.790-08:00Absolutely. Using OVER() is a nice alternative!Absolutely. Using OVER() is a nice alternative!Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-17607973990994069752010-12-21T22:31:32.260-08:002010-12-21T22:31:32.260-08:00My contribution:
Select Grade,
Cast((100*COUNT(...My contribution:<br /><br />Select Grade,<br /> Cast((100*COUNT(*))/Sum(COUNT(*)) Over() As Varchar)+'%' 'Percent' <br />From #ClassRoom <br />Group By Gradeגרי רשף Geri Reshefhttps://www.blogger.com/profile/10571079411615657853noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-4971007175254562182010-12-18T03:59:59.903-08:002010-12-18T03:59:59.903-08:00Good one.Good one.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-84020199146338539612010-12-18T03:59:32.608-08:002010-12-18T03:59:32.608-08:00Good one...Thanks.Good one...Thanks.Anonymousnoreply@blogger.com