表
userid year month date sate
1 2006 2 1 Q
2 2006 2 1 Q
1 2006 2 2 N
2 2006 2 2 N要得出下面的汇总结果:
userid year-month Q N
1 2006-2 2 2
2 2006-2 2 2请问SQL语句该怎么写?希望各位大哥给点提示
userid year month date sate
1 2006 2 1 Q
2 2006 2 1 Q
1 2006 2 2 N
2 2006 2 2 N要得出下面的汇总结果:
userid year-month Q N
1 2006-2 2 2
2 2006-2 2 2请问SQL语句该怎么写?希望各位大哥给点提示
这个意思?select userid,year || '-' || month as year-month,
sum(decode(sate,'Q',1,0)) as Q,
sum(decode(sate,'N',1,0)) as N
from tbl
group by userid,year || '-' || month;
count(sate),sate
from tbl
group by userid, year||'-'||month ,sate;