Question

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

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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

MSSQL 中：

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