Question

在mysql中怎样查询年龄最大的前3个学生年龄和姓名

Answer 1

SELECT username, MAX((YEAR(NOW())- YEAR(出生日期))) AS age
FROM 表 GROUP BY username ORDER BY age DESC LIMIT 3
一句搞定

Answer 2

select name,sex from table order by age desc limit 3;

Answer 3

select name age from table(这里是你的表名) order by age desc limit 3;

Answer 4

select name,sex from table where rownum<4 order by age desc