Query to display duplicate records without using group by

• Use self-join to compare records

• Select records where the values match but the primary key is different

• Example: SELECT a.* FROM table a, table b...read more