用数据库语句查询年龄在19~21范围内的学生信息

用数据库语句查询年龄在19~21范围内的学生信息

select * from student
left join grade
on student.学号 = grade.学号
left join curriculum
on grade.课程编号=curriculum.课程编号
where DateDiff(yy, 出生日学号 期, getdate() ) between 19 and 21追问select * from student
left join grade
on student.学号 = grade.学号
left join curriculum
on grade.课程编号=curriculum.课程编号
where DateDiff(yy, 出生日期，getdate() ) between 19 and 21

select * from student where trunc((sysdate-出生日期)/365) between 19 and 21;