Search repeated rows

QueryStash

With this simple query, you can find duplicate values within a table given a column.

1SELECT surname, COUNT(surname)
2FROM dbo.Students
3GROUP BY surname
4HAVING COUNT (surname) > 1;

SELECT surname, COUNT(surname)
FROM dbo.Students
GROUP BY surname
HAVING COUNT (surname) > 1;

Public

Fabio Ramoni

Created: May 14th 2022

QueryStash

Made with ❤️ by @Yekalb

Resources

Examples

Stay up to date