|id| user_id | created_time | score |
|1| 101 | 2023-01-21 15:46:08 | 11 |
|2| 101 | 2023-01-22 11:46:08 | 33 |
|3| 101 | 2023-01-23 15:46:08 | 22 |
|4| 101 | 2023-01-23 20:46:08 | 22 |
|7| 102 | 2023-01-21 15:46:08 | 11 |
|8| 102 | 2023-01-22 11:46:08 | 33 |
|9| 102 | 2023-01-23 15:46:08 | 22 |
|10| 102 | 2023-01-23 20:46:08 | 22 |
如何查询上表每个userid每一天的最小created_time,SQL怎么写?
//想要的输出结果
|id| user_id | created_time | score |
|1| 101 | 2023-01-21 15:46:08 | 11 |
|2| 101 | 2023-01-22 11:46:08 | 33 |
|3| 101 | 2023-01-23 15:46:08 | 22 |
|7| 102 | 2023-01-21 15:46:08 | 11 |
|8| 102 | 2023-01-22 11:46:08 | 33 |
|9| 102 | 2023-01-23 15:46:08 | 22 |