千家信息网

查询表中 A/B 字段联合是否唯一

发表于:2025-02-02 作者:千家信息网编辑
千家信息网最后更新 2025年02月02日,SELECT column_a,column_b,COUNT(*) as num FROM TABLE GROUP BY column_a,column_b;SELECT column_a,colum
千家信息网最后更新 2025年02月02日查询表中 A/B 字段联合是否唯一
  1. SELECT column_a,column_b,COUNT(*) as num FROM TABLE GROUP BY column_a,column_b;

  2. SELECT column_a,column_b,COUNT(*) as num FROM TABLE group by column_a,column_b having count(*)>1;
0