question

If I had understood your question correctly the below would might help you: CREATE TABLE #Count(colA INT,COLB INT, COLC INT, COLD NCHAR(1)) INSERT INTO #Count VALUES(1,2,3,'A') INSERT INTO #Count VALUES(1,1,3,'A') INSERT INTO #Count VALUES(1,2,3,'A') INSERT INTO #Count VALUES(1,2,3,'A') SELECT COUNT(COLD) FROM #Count GROUP BY colA,COLB,COLC you might want to play a little to get accurate result set based on your schema and environment.