sql语句问题,请指点

SELECT * FROM (SELECT COUNT(列名) AS c,列名 FROM 表名 GROUP BY 列名) a WHERE c >1 ORDER BY c DESC 我这个不就显示重复次数吗? 还是说你想这样,如果有两条记录,就显示重复次数为1?那么这样就可以了SELECT (c-1) as c,列名 FROM (SELECT COUNT(列名) AS c,列名 FROM 表名 GROUP BY 列名) a WHERE c >1 ORDER BY c DESC 收起