p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Beginning ASP.NET 2.0 and Databases (http://p2p.wrox.com/book-beginning-asp-net-2-0-databases-276/)
-   -   Get the percentage of the count result (http://p2p.wrox.com/book-beginning-asp-net-2-0-databases/94618-get-percentage-count-result.html)

honey_mags June 17th, 2015 09:38 PM

Get the percentage of the count result
Hello ma'am/sir, i am asking your big help for this...
I am developing an Online Voting System in ASP.NET with the database from MS ACCESS, i'm having a problem in getting the percentage results in vote count instead of integer.

Here is my query:

SELECT COUNT(Result.gov) AS countgov, tblCandidates.[Full Name] FROM (Result INNER JOIN tblCandidates ON Result.gov = tblCandidates.ID) GROUP BY tblCandidates.[Full Name] HAVING (COUNT(Result.gov) > 0) ORDER BY COUNT(Result.gov) DESC

All times are GMT -4. The time now is 07:16 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.