SELECT count(*), IndentId FROM t_customerforsale -- WHERE -- IndentId = '' GROUP BY IndentId HAVING count(*) > 1;
MySql查重语句,整理数据的时候常用到。
SELECT count(*), IndentId FROM t_customerforsale -- WHERE -- IndentId = '' GROUP BY IndentId HAVING count(*) > 1;
MySql查重语句,整理数据的时候常用到。
转载于:https://www.cnblogs.com/zran/p/9294659.html