Duplicate Records only where a specific condition exists
I have a table containing Display Text, A Link Field, and a Category.
I am trying to find duplicate links, BUT only if they have the same Category.
Right now I am using a query that shows me all duplicates regardless of the category they are in. Can anyone help me figure out the missing piece for the same category part?
Here is my query:
GROUP BY lnktxt
HAVING count( lnktxt ) >1
ORDER BY lnktxt