Question

在sql中查寻年龄最大和最小的女学生年龄，及其对应姓名。

Answer 1

select 姓名,年龄
from 学生表
where (年龄=(select max(年龄) from 学生表 where 性别='女')
or 年龄=(select min(年龄) from 学生表 where 性别='女'))
and 性别='女'

Answer 2

年龄最大的：select top 1 * from 表 order by 年龄 desc
年龄最小 的：select top 1 * from 表 order by 年龄

Answer 3

很简单
select * from tb
where age in
(
select min(age) age from tb
union all
select max(age) from tb
)
and sex='女'

Answer 4

select age,user from tb_user where age in(select max(age),min(age) from tb_user) order by age desc

Answer 5

select name,min(age) from 表 where and sex='女'
union all
select name,max(age) from 表 where and sex='女'