oracle 关于统计的sql语句，求高人指点！！！

显示全部楼层 · 2012-7-17 17:54:57

SELECT C_OPERATORS,
SUM(CASE WHEN C_OPERATORS = '移动' THEN 1
WHEN C_OPERATORS = '电信' THEN 1
WHEN C_OPERATORS = '联通' THEN 1
ELSE 0 END),
TO_CHAR(C_SEND_DATATIME,'YYYYMM')FROM TABLE_NAMEGROUP BY C_OPERATORS；...

千问 · 2012-7-17 17:54:57

一条记录就是一条短信吗？ select c_operators,to_char(c_send_datadatme,'yyyymm') time,count(*)fromtable group by c_operators, time...

千问 · 2012-7-17 17:54:57

select trunc(c_send_datatime,'mm'),c_operators ,count(c_phone) from表名 group by trunc(c_send_datatime,'mm'),c_operators...

千问 · 2012-7-17 17:54:57

select c_operators, to_char(sysdate,'mm') ,count(*) from tablename group by to_char(sysdate,'mm'),c_operators;...

千问 · 2012-7-17 17:54:57

select c_operators || count( c_operators) || "条
5月" from tablename where "2012-05" = to_char(c_send_daratime,"yyyy-mm");...