MySQL 查询各年龄段

btegc

于 2019-04-06 20:41:57 发布

阅读量1.9k

点赞数

分类专栏： SQL 文章标签： MySQL 年龄段

本文链接：https://blog.csdn.net/btegc/article/details/89060134

版权

SELECT (CASE WHEN CAST(age AS SIGNED) >= 18 and CAST(age AS SIGNED) <= 29 THEN '18-29岁' WHEN CAST(age AS SIGNED) >= 30 and CAST(age AS SIGNED) <= 39 THEN '30-39岁' WHEN CAST(age ...

摘要由CSDN通过智能技术生成

SELECT 
  (CASE 
	WHEN CAST(age AS SIGNED) >= 18 and CAST(age AS SIGNED) <= 29 THEN
		'18-29岁'
	WHEN CAST(age AS SIGNED) >=

最低0.47元/天解锁文章

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

btegc

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
MySQL 查询各年龄段

SELECT (CASE WHEN CAST(age AS SIGNED) >= 18 and CAST(age AS SIGNED) <= 29 THEN '18-29岁' WHEN CAST(age AS SIGNED) >= 30 and CAST(age AS SIGNED) <= 39 THEN '30-39岁' WHEN CAST(age ...
复制链接

扫一扫