select ifnull(a.tab_name_ch,'合计') 业务名称,min(create_Time) 第一笔业务日期,count(1) 参与人次小计
from wf_hist_task a
group by a.tab_name_ch
WITH ROLLUP; limit 10
select tab,count(1) cnt ,sum(lr) je from v_tj_sjbxx group by tab
drop view if exists v_tj_sjbxx;
create view v_tj_sjbxx as
select 't_xm_xmysxx' tab,a.lr,id ,lrr,bmmc,lrsj from t_xm_xmysxx a union all
select 't_xm_xmjk' tab,(a.lr) ,id ,lrr,bmmc,lrsj from t_xm_xmysxx a union all
select 't_xm_xmbx' tab,(a.lr) ,id ,lrr,bmmc,lrsj from t_xm_xmysxx a union all
select 't_xm_xmjk' tab,(a.lr) ,id ,lrr,bmmc,lrsj from t_xm_xmysxx a union all
select 't_xm_xmysxx1' tab,(a.lr) ,id ,lrr,bmmc,lrsj from t_xm_xmysxx a union all
select 't_xm_xmysxx2' tab,(a.lr) ,id ,lrr,bmmc,lrsj from t_xm_xmysxx a
有没有哪位大佬帮我解释一下这些数据库语句
