Thank you both very much. Im using a CTE pretty simply now.

with cte as

(select name, col2, col3, COUNT(*) over (PARTITION By Name, col2, col3) as freq

from mytable)

select * from cte

where freq>1

Logic works. Now to implement in a much more complex way. 🙂

Thanks again!