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;
Fabio Ramoni
Created: May 14th 2022
Made with ❤️ by @Yekalb
© 2024 Query Stash. All rights reserved
Resources
Examples
Stay up to date