TableA has the data as follows:

```
Col1    Col2    Col3
001     A       0
001     B       0
002     C       0
003     D       0

```

I want to see the count of records `group by` `Col1` and `Col2` where `Col3 = 1`
May be the query as follows:

```
Select Col1, Col3, Count(1)
From TableA
Group By Col1, Col2
Where Col3 = 1

```

Since there are no records with `Col3 = 1` no records will be displayed, but I still want to display the values with count as 0.
For example the output is as follows:

```
Col1    Col2    CountOfRecords
001     A       0
001     B       0
002     C       0
003     D       0

```

Could you please help me to get output as shown above.