Unanswered: Trying to retrieve rows with a duplicate column
I am trying to retrieve just the rows that have a duplicate column value from a distinct result set.
If I do SELECT DISTINCT col1, col2 FROM table I get....
From these results I am trying to retrieve just the rows that have duplicates in col1, in this case just the rows where col1 has a value of 2. After everything I have tried, I can't get just these 2 rows. Any help would be greatly appreciated. Thanks in advance.