6
这个问题能用一个 select 实现吗
source link: https://www.v2ex.com/t/797993
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
表结构以及数据如图 1,要求只使用一个“select”从这个表中筛选出 2017 年 7 月份各性别的开户人数统计结果,结果格式如图 2
图 2 ![]( https://pic.imgdb.cn/item/6126204744eaada73936ff8e.png)
第 1 条附言 · 19 小时 18 分钟前
我知道如何通过身份证号取性别
9 条回复 • 2021-08-25 20:28:58 +08:00
crystom 19 小时 14 分钟前 1
select count(distinct kahao), IF(SUBSTR(idcard, LENGTH(idcard) - 1, 1) % 2 = 1, '男','女') AS sex from tablename where ds >= '2017-07-01' and ds <= '2017-07-31' group by 2
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK