Find duplicate values

Group by the column and keep groups with more than one row.

More SQL recipes

• Get the top N rows per query
• Find rows with no match in another table
• Calculate a running total
• Pivot values into columns with CASE
• Count rows per group