CODEWITHSUNDEEP
c#sql
CCC
CCC

Reputation: 2242

How do I count multiple columns in SQL Server?

I have a table like this:

enter image description here

How do I count rows that have identical values in columns A,B,C,D ?

The column 'ID' will be ignored.

For this case, the count result is 2.

Upvotes: 8

Views: 18103

Answers (1)

marc_s
marc_s

Reputation: 754478

How about:

 SELECT COUNT(*), A, B, C, D
 FROM dbo.YourTable
 GROUP BY A, B, C, D
 -- optional - if you want to skip all the rows that occur only once
 -- HAVING COUNT(*) > 1

Basically, you just group your data by the columns of interest, and let SQL count the rows that match each set of column values.

Upvotes: 17

Related Questions