Duplicate Records only where a specific condition exists

[mharrison]

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:

SELECT *
FROM patterns
WHERE lnktxt
IN (
SELECT lnktxt
FROM patterns
GROUP BY lnktxt
HAVING count( lnktxt ) >1
)
ORDER BY lnktxt

[Old Pedant]

SELECT P1.some, P1.fields
FROM patterns AS P1, 
     ( SELECT lnktxt, category, COUNT(*) AS howmany
      FROM patterns 
      GROUP BY linktxt, category
      HAVING howmany > 1 ) AS P2
WHERE P1.lnktxt = P2.lnktxt AND P1.category = P2.category

???

If I understood what you were saying.