首頁猿問請(qǐng)教大家一個(gè)三級(jí)分銷業(yè)績統(tǒng)計(jì)的My...

請(qǐng)教大家一個(gè)三級(jí)分銷業(yè)績統(tǒng)計(jì)的MySQL查詢語句問題

MySQL PHP 數(shù)據(jù)結(jié)構(gòu)

愿夜幕永不開啟 2017-09-23 19:53:20

如上圖所示, 用到的字段有 uid(用戶id) ?pid(直接推薦人ID) ?ppid(間接推薦人ID) ?fen(銷售份數(shù)) ?addtime(購買的時(shí)間)要求為統(tǒng)計(jì)所有 pid ppid uid 的銷售份數(shù)總和按時(shí)間段來排序.說明三級(jí)分銷的業(yè)績是累加的. 也就是要把這個(gè)表中所有 pid,ppid,uid為同一個(gè)id值的時(shí)候統(tǒng)計(jì)出銷售份數(shù)之和,并排序.想問下這個(gè)能實(shí)現(xiàn)么. (目前僅能得到單個(gè)字段的統(tǒng)計(jì)結(jié)果)$time1 $time2 是起止時(shí)間"SELECT uid,SUM(fen) as fen FROM yh_sales WHERE addtime BETWEEN $time1 AND $time2 ?GROUP BY 1 ?ORDER BY 2 DESC LIMIT 0 , 5"

查看完整描述

1 回答

已采納

是王小二呀

TA貢獻(xiàn)88條經(jīng)驗(yàn) 獲得超19個(gè)贊

select?id,sum(counts)?as?total?from?(
select?pid?as?id,sum(fen)?as?counts?from?yh_sales??group?by?pid?
union?all
select?ppid?as?id,sum(fen)?as?counts?from??yh_sales??group?by?ppid
union?all
select?uid?as?id,sum(fen)as?counts?from??yh_sales??group?by?uid)?tab?
group?by?id

沒搞明白你這個(gè)按照時(shí)間排序，是按照誰的時(shí)間？ pid？uid？ppid？，自己看著join一下再選時(shí)間【】排一下序吧。

1 反對(duì) 回復(fù) 2017-09-28