SQL这道题怎么做?

2025-05-10 21:37:36
推荐回答(2个)
回答1:

select *
from student
order by class,sbirthday desc

回答2:

SELECT s.*,YEAR(NOW())-YEAR(s.SBIRTHDAY) as age from student s ORDER BY class desc,age DESC;