分类：身份证号得到省市

2020
10-07

Oracle按身份证号得到省市、性别、年龄的示例代码

1、通过身份证号查询所在省市SELECTcount(*)astotal,casesubstr(t.CERTNO,0,2)when'11'then'北京市'when'12'then'天津市'when'13'then'河北省'when'14'then'山西省'when'15'then'内蒙古自治区'when'21'then'辽宁省'when'22'then'吉林省'when'23'then'黑龙江省'when'31'then'上海市'when'32'then'江苏省'when'33'then'浙江省'when'34'then'安徽省'when'35'the... 继续阅读 >