trans_no, rybh, bnyrxm, gmsfzh, nyrq select from bazw where gmsfzh = #{idnumber,jdbcType=VARCHAR} SELECT FROM bazw a WHERE a.gmsfzh IS NOT NULL AND a.gmsfzh IN ( #{item} ) AND trans_no = (SELECT MAX(trans_no) -- 因为指纹库可能存在身份证重复的记录，这边取最大的trans_no那条 FROM bazw WHERE gmsfzh = a.gmsfzh)