How to find duplicate records in sql without group by

Problem

You have duplicate rows in your table, with only the IDs being unique.

How to delete duplicate rows in sql

Sql duplicate rows with different value

Find duplicate rows in sql with multiple columns

How to duplicate rows in sql server

How to find duplicate records in sql w3schools

How do you find those duplicate entries?

Example

Our database has a table named with data in the following columns: , , and .

id	name	category
1	steak	meat
2	cake	sweets
3	steak	meat
4	pork	meat
5	cake	sweets
6	cake	sweets

Let’s find duplicate names and categories of products.

You can find duplicates by grouping rows, using the aggregate function, and specifying a clause with which to filter rows.

Solution

SELECT name, category, FROM product GROUP BY name, category HAVING COUNT(id) > 1;

This query returns only duplicate records—ones that have the same product name and category:

name	category
steak	meat
cake	sweets

There are two duplicate products in our table: steak from the meat category and cake from the sweets category.

The first product is repeated two times in the table, while the second appears three times.

Discussion

To select duplicate values, you need to create groups of rows with the same values and then select the groups wit

how to find duplicate rows in sql table

how to find duplicate rows in sql based on one column