MySQL 查询各年龄段
生活随笔
收集整理的這篇文章主要介紹了
MySQL 查询各年龄段
小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.
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 AS SIGNED) >= 40 and CAST(age AS SIGNED) <= 49 THEN'40-49歲'ELSE'-1'END) as '年齡段',id,`name`,gender,age
FROM user;
| 30-39歲 | 1 | 張三 | 30 |
| -1 | 2 | 張三 | 0 |
| 18-29歲 | 3 | 張三 | 23 |
總結(jié)
以上是生活随笔為你收集整理的MySQL 查询各年龄段的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： java毫秒_JAVA中怎么获取毫秒和微
- 下一篇： android版局域网限速,局域网手机W