CREATE TABLE t
(STUDENT int, SCORE int, DATE date)
;
INSERT INTO t
(STUDENT, SCORE, DATE)
VALUES
(1, 6, '2022-02-01 00:00:00'),
(1, 2, '2022-03-12 00:00:00'),
(1, 5, '2022-04-30 00:00:00'),
(2, 2, '2022-04-12 00:00:00'),
(2, 0, '2022-04-17 00:00:00'),
(2, 7, '2022-05-08 00:00:00'),
(3, 2, '2022-03-16 00:00:00'),
(3, 3, '2022-03-18 00:00:00'),
(3, 2, '2022-04-02 00:00:00'),
(3, 9, '2022-04-27 00:00:00'),
(4, 4, '2022-02-24 00:00:00'),
(4, 0, '2022-02-26 00:00:00'),
(5, 3, '2022-01-28 00:00:00'),
(5, 0, '2022-02-21 00:00:00'),
(5, 4, '2022-04-05 00:00:00')
;
SELECT STUDENT, min(DATE) as min_date
from t
where SCORE = 2
group by STUDENT
这是可行的,但我希望包括所有的‘学生’,如果一个学生在任何时候的分数都不是2,则日期的值为空