简介:通过身份证后七位减最后一位查询
personinfo表中对应的身份证号字段是card,假设身份证号为412256199109022456,则sql语句为:
SELECT A2.CARD,"SUBSTR"(A2.CARD, "LENGTH"(A2.CARD)-6, 6)FROM PERSONINFO a2
截取的结果为:902245
简介:通过身份证后七位减最后一位查询
personinfo表中对应的身份证号字段是card,假设身份证号为412256199109022456,则sql语句为:
SELECT A2.CARD,"SUBSTR"(A2.CARD, "LENGTH"(A2.CARD)-6, 6)FROM PERSONINFO a2
截取的结果为:902245