Query repeating columns

Today, this problem is not found on the Internet. So I studied it, get the following statement can be, but the efficiency may not be too high: Select *from table name where (column name in (SELECT column name-This column name is somewhat limited, there are many data types do not support] from table name Column name GROUP by column name, column name having COUNT (column name) >1)) ORDER by column name The following is an example: Select *from authorswhere (au_lname in (select au_lname from AUT Hors au_lname GROUP by au_lname, au_lname have COUNT (au_lname) > 1)) ORDER by au_lname

Query repeating columns