年龄小于20岁和大于20岁的sql语句怎么写

where age<20

select case when Age<20 then '年龄较小' when Age>=20 and age<24 then '年龄适中' else '年龄偏大' end Memo from Student

要查询“计算机系小于20岁的学生”，首先需要明确SQL查询语句。具体语句如下：设SQL查询语句为：`SELECT 姓名, DATEDIFF(LEFT(当前日期,4), 出生日期, 'YYYY') as 年龄 FROM 学生表 WHERE 系别='计算机' AND DATEDIFF(LEFT(当前日期,4), 出生日期, 'YYYY') < 20;`这里的`DATEDIFF()`函数用于计...

when datediff(year,出生年月,getdate()) between 21 and 25 then '21-25年龄段'else '25以上年龄段' end 也可以试试 select sum(case when datediff(year,出生年月,getdate()) <= 20 then 1 else 0 end) '20岁年龄段',sum(case when datediff(year,出生年月,getdate()) between 21 ...

你好，很高兴回答你的问题。可以通过类似下面的sql语句来实现你的需求。select 姓名,年龄 from 表 where 年龄<20。将其中的表名和列名改成你使用的表名列名即可。如果有帮助到你，请点击采纳。

在修改一下：select count(1), xh from (select (datediff(year,age2,getdate())-case when datediff(day,dateadd(year,datediff(year,age2,getdate()),age2),getdate()) >=0 then 0 else 1 end) as 'xh' , id from t_age ) a where xh > 20 ...

SELECT a.学号, b.姓名, b.性别, datediff('yyyy',b.出生日期,now()) AS 年龄, a.课程A, a.课程B, a.课程C, a.课程D, a.课程E FROM 学生成绩 AS a INNER JOIN 学生档案 AS b ON a.学号=b.学号 WHERE datediff('yyyy',b.出生日期,now())<20;...

SQL数据库查询语句：（1）在20岁以下 select * from 表 where datediff(year,出生日期,getdate())<20 （2）20-30岁 select * from 表 where datediff(year,出生日期,getdate()) between 20 adn 30 （3）30岁以的SQL误句 select * from 表 where datediff(year,出生日期,getdate())>30 ...

Age,Sex4、结果：按年龄段分组 1、sql select count(*) as 'count',Sex,case when Age<=10 then '小于等于十岁' when Age>10 then '大于十岁' end as AgeRange from Usersgroup by (case when Age<=10 then '小于等于十岁' when Age>10 then '大于十岁' end ),Sex2、结果 ...

select datediff(year,birthday,getdate()) as age from a where datediff(year,birthday,getdate())>20