Mysql表Call_hist結構是這樣的 Mobile Name Amount Day --------------------------------------1234567890 Pra 70 Sunday 9876543210 Spe 63 Sunday 9876543210 Spe 380 Sunday 1234567890 Pra 888 Monday 9876543210 Spe 70 Monday 9876543210 Spe 630 Monday 我想像下面這樣對這些數據進行排序 Mobile Name Day Reps ------------------------------------------ 1234567890 Pra Sunday 1 9876543210 Spe Sunday 2 1234567890 Pra Monday 1 9876543210 Spe Monday 2請協助我。
2 回答
九州編程
TA貢獻1785條經驗 獲得超4個贊
我假設你正在追逐這個...
SELECT mobile
, name
, day
, COUNT(*) reps
FROM my_table
GROUP
BY mobile
, name
, day
ORDER
BY day DESC -- THERE ARE OTHER WAYS TO SORT DAYS OF THE WEEK
, reps;
+------------+------+--------+------+
| mobile | name | day | reps |
+------------+------+--------+------+
| 1234567890 | Pra | Sunday | 1 |
| 9876543210 | Spe | Sunday | 2 |
| 1234567890 | Pra | Monday | 1 |
| 9876543210 | Spe | Monday | 2 |
+------------+------+--------+------+
Helenr
TA貢獻1780條經驗 獲得超4個贊
我認為您希望按移動設備，名稱和日期進行聚合，并計算不同的金額：
SELECT
Mobile,
Name,
Day,
COUNT(DISTINCT amount) AS Reps -- see below **
FROM yourTable
GROUP BY
Mobile,
Name,
Day;
**如果同一值出現的次數也應計算在內，則只需使用 。COUNT(*)
- 2 回答
- 0 關注
- 125 瀏覽
添加回答
舉報
0/150
提交
取消