全部答案

2014-01-04 14:38:55

• 比如身份信息表是 identity 表 身份证号列名为 number ,表的主键为: id，那么查询语句为：
  select a.number as number1, b.number as number2,a.id as id1,b.id as id2
  from identity as a inner join identity as b
  on a.number = b.number
  where a.id != b.id

  全部
  

  听***

  2014-01-04 14:38:55

  561 323 评论

  分享
  提交评论