mysql查询每个班上最小年龄的学员

Question

sno    sname ssex  sbirthday                     class

101    李军    男     1976-02-20 00:00:00    95033
103    陆君    男     1974-06-03 00:00:00    95031
105    匡明    男     1977-10-02 00:00:00    95031
107    王丽    女     1976-01-23 00:00:00    95033
108    曾华    男     1977-09-01 00:00:00    95033
109    王芳    女     1975-02-10 00:00:00    95031
110    王芳    女     1978-02-10 00:00:00    95031
111    王五    男     1974-06-01 00:00:00    95033

 

查询每个班上年纪最小的学员。

不要limit做，会导致班级定死，如果有很多个班级就不方便使用limit了

错误代码：

select * from students where year(sbirthday) in(select max(year(sbirthday)) from students group by class) ;

 

select * from students where year(sbirthday) in(select max(year(sbirthday)) from students group by class) group by class;

Answer 1

select * from students  where (year(sbirthday),class)in(select max(year(sbirthday)),class from students group by class)