COUNT instances of 3 columns

Hi,
I need to identify where a combination of 3 Columns occurs more than once.

What I have so far (simplified for the post)

SELECT A, B,C
FROM tblX

GROUP BY A,B,C
HAVING COUNT A > 1
AND COUNT B > 1
AND COUNT C > 1

Any help would be appreciated.

Comments

  • : Hi,
    : I need to identify where a combination of 3 Columns occurs more than
    : once.
    :
    : What I have so far (simplified for the post)
    :
    : SELECT A, B,C
    : FROM tblX
    :
    : GROUP BY A,B,C
    : HAVING COUNT A > 1
    : AND COUNT B > 1
    : AND COUNT C > 1
    :
    : Any help would be appreciated.
    :
    Try This,

    SELECT COUNT(A+B+C)
    FROM TABLE
    HAVING COUNT(A+B+C)>1
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion