CodingForums.com - View Single Post - Duplicate Records only where a specific condition exists

Old Pedant · 12-17-2012, 01:05 AM

Code:

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.

12-17-2012, 01:05 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,210 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	Code: 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. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.