我有一個截圖表，我想讓用戶截圖時間開始和截圖時間結束。我想創建一個查詢，以便能夠匯出資料以提供給我的用戶。
假設這是我的表格資料。
| scs_id | scs_tracker_id | created_at |
|---|---|---|
| 1 | 1000 | 2022-02-22 00:00:00 |
| 2 | 1001 | 2022-02-22 04:00:00 |
| 3 | 1000 | 2022-02-22 01:00:00 |
| 4 | 1002 | 2022-02-22 12:00:00 |
| 5 | 1001 | 2022-02-22 08:00:00 |
| 3 | 1000 | 2022-02-22 02:00:00 |
我的預期輸出應該是：
| scs_tracker_id | screenshot_starts | screenshot_ends |
|---|---|---|
| 1000 | 2022-02-22 00:00:00 | 2022-02-22 02:00:00 |
| 1001 | 2022-02-22 04:00:00 | 2022-02-22 08:00:00 |
| 1002 | 2022-02-22 12:00:00 | 2022-02-22 12:00:00 |
我目前正在玩的代碼：
SELECT
(SELECT MIN(created_at) FROM screen_shots GROUP BY scs_tracker_id ORDER BY scs_id ASC LIMIT 1) AS screenshot_starts,
(SELECT MAX(created_at) FROM screen_shots GROUP BY scs_tracker_id ORDER BY scs_id DESC LIMIT 1) AS screenshot_ends
FROM screen_shots
uj5u.com熱心網友回復：
按跟蹤器 ID 聚合，然后獲取最小/最大時間戳：
SELECT
scs_tracker_id,
MIN(created_at) AS screenshot_starts,
MAX(created_at) AS screenshot_ends
FROM screen_shots
GROUP BY scs_tracker_id;
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/430921.html