How do I detect a duplicate row in database table with sql?
i want to detect the duplicate columns of database table. the sql is given below: select column_name, count( column_name ) as number_of_occurrences from table_name Group_by column_name Having(count( column_name )>1) limit 0,100 SELECT MemberId , COUNT ( MemberId ) AS NumOccurrences FROM members GROUP BY MemberId HAVING ( COUNT ( MemberId ) > 1 ) LIMIT 0 , 238