sql语句判断身份证性别等

SELECT  t.card_number '身份证号',SUBSTR(t.card_number,1,2) AS "省份",
SUBSTR(t.card_number,7,4)    "出生年月",
SUBSTR(t.card_number,17,1)  "性别" ,
CASE (SUBSTR(t.card_number,17,1)%2)
WHEN 1 THEN ''
WHEN  0 THEN ''
END AS  '性别'  
FROM user t ;

 

posted @   kangjie  阅读(12607)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示