Return all duplicate rows
You have to join back to the table again to get the duplicates I think. Something like:
SELECT * FROM StyleTable WHERE Color IN ( SELECT Color FROM StyleTable GROUP BY Color HAVING count(*) > 1 )
SELECT s.* FROM StyleTable s INNER JOIN (SELECT Color FROM StyleTable GROUP BY Color HAVING COUNT(*) > 1) q ON s.Color = q.Color
WITH cte AS ( SELECT FirstName, LastName,COUNT(*) occurrences FROM Customer GROUP BY FirstName, LastName HAVING COUNT(*) > 1)SELECT * FROM Customer INNER JOIN cte ON cte.FirstName = Customer.FirstName AND cte.LastName = Customer.LastNameORDER BY Customer.FirstName, Customer.LastName