How to find the same data in MySQL

Ideas:

In the table 6, 7th data, their except the ID is different, the other data is the same; first, a combination primary key is found in the table, then the primary key group By then calculates a record greater than 1, and then the record is found by combining the primary key, and then it can be found. Two identical records were found,

Select     * fromTb_stu asTJoin    (Select         Count(*) asamount, T5.stuid, T5.stuname from        (Select         *     fromTb_stu asS asT5Group  byStuid, T5.stuname) asT5 onT.stuid=T5.stuid andT.stuname=T5.stunamewhereT5.amount> 1

How to find the same data in MySQL