Jerry
|
| Posted: 07/23/2003, 5:30 AM |
|
I am using the following sql statement to gain the results of a survey and would like to convert the figure into a percentage
review = table
organise = column
Select Count(organised) AS Label1 From review Where organised = 1
|
|
|
 |
It Farmer
|
| Posted: 07/23/2003, 4:49 PM |
|
([CountOfColumn1]/[CountOfColumn2])* 100 AS PERCENTAGE
Fore example i want to know the % of black cats in my database.
CountOfColumn1 = total counts where black cats
CountOfColumn2 = total records in the database
This returns a 0.xx value if done correctly. Multiply this by 100 (*100) and you get the full percentage.
Hope this helps.
|
|
|
|
|
