计算SQLITE中单个记录的百分比

Question

我有Register表，其中有以下字段，如：

r_id , f_name , l_name , isactive , pkg

pkg字段的值可以是1,2,3,4。我想知道有多少用户具有pkg值1和2以及3和4的百分比。我使用了以下查询，但它对我不起作用。

SELECT COUNT(*) as cnt ,SUM(r_id) as sumSales ,AVG(r_id)*100 as avgSales
FROM reg where pkg=1

Answer 1

请尝试以下代码

SELECT pkg,ROUND((count(*)*100)/(SELECT count(*) FROM reg)) as percentage
FROM reg group by pkg

Try is yourself on SqlFiddle

Answer 2

如果我必须在网络上这样做，我会走这条路。。

SELECT pkg,ROUND((count(*)/(SELECT count(*) FROM register))*100) as percentage FROM `register` group by pkg

希望它也能在Android上运行；）