数据库中查找年龄最大的学生的姓名？

数据库中查找年龄最大的学生的姓名？
表：ID name sex age
该如何？

---

SELECT
name
FROM
表肢改历槐
WHERE
age = (SELECT MAX(age) FROM 表历烂判 )

---

select name,age from student where age in (select Max(isnull(age,0)) from student)

---

select name from 表 where age = (select max(age) from 表)

---

MSSQL 中橡兄悄梁渣：

SELECT name
FROM 表 WHERE (age =
(SELECT MAX(age)
FROM 表尘答))

---