1条回答
- 旺卡_大流量卡 2019-08-29 15:05关注
你在逗我吗,
select * from (select ('第' ||(to_char(create_time,'iw')-15)||'周') as zhou, nvl(count(distinct mname),0) as zongl from stunem t group by to_char(create_time,'iw') order by to_char(create_time,'iw')) where zongl != 0解决评论 打赏 举报无用 1