mysql订单统计
发表于 2021-1-29 | | 开发笔记

-- 每日单量

select DATE_FORMAT(createtime,'%Y-%m-%d') as days,count() count from ibt_shop_order group by days;

-- 每周单量

select DATE_FORMAT(createtime,'%Y-%u') as weeks,count(
) count from ibt_shop_order group by weeks;

-- 每月单量

select DATE_FORMAT(createtime,'%Y-%m') as months,count() count from ibt_shop_order group by months;



SELECT
FROM jsc_order_refund where refund_status = 0 and refund_money > 1



-- 每季度

SELECT click_date as q,IFNULL(b.con,0) as c FROM(SELECT  1 as click_date UNION ALL

SELECT  2 as click_date UNION ALL

SELECT  3 as click_date UNION ALL

SELECT  4 as click_date) a LEFT JOIN(

SELECT QUARTER(from_unixtime(create_time,'%Y%m%d')) as mon, COUNT(*) as con FROM gwc_enter_orders GROUP BY QUARTER(from_unixtime(create_time,'%Y%m%d')))

b ON click_date=b.mon

发表评论:

TOP