SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user group by dt order by dt desc limit 20;
SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user where `parent_id` <> '' group by dt order by dt desc limit 20;
最后得到一張表，安日期分組，第二張圖日期沒(méi)有的num為0？？求大神指導(dǎo)
2 回答
MM們
TA貢獻(xiàn)1886條經(jīng)驗(yàn) 獲得超2個(gè)贊
SELECT from_unixtime(regtime, '%Y%m%d') dt , sum(case when parent_id='' then 0 else 1 end) num from android_user group by dt order by dt desc limit 20;
皈依舞
TA貢獻(xiàn)1851條經(jīng)驗(yàn) 獲得超3個(gè)贊
你這個(gè)是一張表吧？可以使用一條sql語(yǔ)句呀。
SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user where `parent_id` <> '' group by dt order by dt desc limit 20;- 2 回答
- 0 關(guān)注
- 362 瀏覽
添加回答
舉報(bào)
0/150
提交
取消