sql 查询数据条数

来源：百度知道 编辑：UC知道 时间：2024/06/19 20:05:12
有这样一个sql 语句 select group_id=CASE WHEN v.billing_status=''R'' THEN ''R'' WHEN v.billing_status=''E'' THEN ''E'' ELSE ''A'' END from bcw_voucherwktbl_pre v where.......
现在要添加一个语句 计算当group_id='R'的时候数据有几条， 当group_id='E'的时候数据有几条，当group_id='A'的时候数据有几条，
急 在线等 回答的好 我会追加分的！

select count(*),group_id=CASE WHEN v.billing_status=''R'' THEN ''R'' WHEN v.billing_status=''E'' THEN ''E'' ELSE ''A'' END from bcw_voucherwktbl_pre v where....... group by group_id

select group_id,count(*)
from bcw_voucherwktbl_pre v
group by group_id

select count(*),group_id=CASE WHEN v.billing_status='R' THEN 'R' WHEN v.billing_status='E' THEN 'E' ELSE 'A' END from bcw_voucherwktbl_pre v where 你的条件 group by group_id

SELECT SUM(DECODE(v.billing_status,'R',1,0)) AS "R-COUNT",
SUM(DECODE(v.billing_status,'E',1,0)) AS "E-COUNT",
SUM(DECODE(v.billing_status,'A',1,0)) AS "A-COUNT"
FROM bcw_voucherwktbl_pre v where.......