[SQL Server]一条查询30天内订单信息的统计sql

楼主^#

更多发布于：2012-10-30 10:46


	一条查询30天内订单信息的统计sql java代码 select m.distribution_station_name,sum(if(m.mon_audit_status=0,1,0)),sum(if(m.mon_audit_ status=1,1,0)),m.distribution_member_name,m.distribution_member_id,sum(real_pay), sum(need_pay),sum(loss),sum(unpay) from( www.atcpu.com select ds.distribution_station_name,dm.distribution_member_name,dm.distribution_member_id, fr.order_code as orderCode, if(fr.mon_audit_status=1,ifnull(oa.cash,fr.cash),0) as real_pay, if(fr.mon_audit_status=1,fr.cash,0) as need_pay, if(fr.mon_audit_status=1,fr.cash-ifnull(oa.cash,fr.cash),0) as loss, if(fr.mon_audit_status=0,fr.cash,0) as unpay, fr.mon_audit_status from backend.finance_report fr join tms.distribution_member dm on fr.main_distribution_member_id = dm.distribution_member_id join tms.distribution_station ds on ds.distribution_station_id=dm.distribution_station_id left join backend.order_account oa on oa.order_code=fr.order_code and fr.order_arrived_time>DATE_FORMAT(DATE_SUB(CURRENT_DATE,interVAL 29 DAY), '%Y-%m-%d'))m group by m.distribution_station_name,m.distribution_member_name,m.distribution_ member_id