select t.card ,substr(card, 17,1 ) %2, case substr(card, 17,1) %2 when '1' then '男' else '女' end as gender from account_gtgj t
sql 查询男女
最新推荐文章于 2023-10-27 15:56:08 发布
select t.card ,substr(card, 17,1 ) %2, case substr(card, 17,1) %2 when '1' then '男' else '女' end as gender from account_gtgj t