Question

access数据库 查找年龄小于平均年龄的学生,怎么弄？

Answer 1

Access
数据库同样支持
SQl
语句的查询
select
*
from
[表名]
where
[age]<(select
avg(age[年龄])
from
[表名])
例如:
表名为
students
年龄字段名为
age
则语句为:
select
*
from
students
where
age<(
select
avg(age)
from
students
)完成查询;

Answer 2

Access
数据库同样支持
SQl
语句的查询
select
*
from
[表名]
where
[age]<(select
avg(age[年龄])
from
[表名])
例如:
表名为
students
年龄字段名为
age
则语句为:
select
*
from
students
where
age<(
select
avg(age)
from
students
)完成查询;

Answer 3

在查询的设计页面中，在条件处填写：<(select Avg([年龄])from[数据表的名称]）

Answer 4

select *
from tab
where age < (select avg(age) from tab)

Answer 5

where age < (select avg(age) from 表)