CREATETABLE `user` (  `name` varchar(10) DEFAULT NULL,  `age` int(3) DEFAULT NULL,  `sex` char(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DELETEFROM  `user`
WHERE(`name`, `age`, `sex`)IN(SELECT      a.`name`,      a.`age`,      a.`sex`
FROM(SELECT          `name`,          `age`,          `sex`
FROM          `user`
GROUPBY          `name`,          `age`,          `sex`
HAVINGcount(1)>1) a
)LIMIT1;