lundi 16 février 2015

Calculate percentage for single record in SQLITE

Hello firends i have register tabel and in this i have following fields like


r_id , f_name , l_name , isactive , pkg


in pkg field value has 1,2,3,4 and in this i want to find out percentage of like how many user has pkg value 1 and 2 and 3 and 4 i use following query but it is not work for me



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

Aucun commentaire:

Enregistrer un commentaire