<--------------------------cut---------------------------->
SELECT *, COUNT(*) AS count
FROM name GROUP BY name
HAVING count > 1
ORDER BY count, name
<--------------------------cut---------------------------->
# phpMyAdmin MySQL-Dump
#
http://phpwizard.net/phpMyAdmin/#
# Host: Database : develop
# --------------------------------------------------------
#
# Table structure for table \'name\'
#
DROP TABLE IF EXISTS name;
CREATE TABLE name (
name varchar(255) NOT NULL
);
#
# Dumping data for table \'name\'
#
INSERT INTO name VALUES ( \'a\');
INSERT INTO name VALUES ( \'b\');
INSERT INTO name VALUES ( \'b\');
INSERT INTO name VALUES ( \'c\');
INSERT INTO name VALUES ( \'c\');
INSERT INTO name VALUES ( \'c\');
INSERT INTO name VALUES ( \'d\');
<--------------------------cut---------------------------->