Can I use 'GROUP BY' on a 'bit' -column?

[jonash]

When I use GROUP BY on a 'bit' -column I get an errormessage. Is this a possible statement? Can I do this any other way?

 

[rajeevnandanmishra]

Hi jonash,
Will you please give your sql statement and the error message you are getting.

 

[Cagliostro]

some possible solution:

select count(*)
from
(select a,b, cast(someBitCol as int) x) t
group by t.x John Fill

ivfmd@mail.md

 

[rajeevnandanmishra]

Hi jonash,

You can use this also,
select case mybitfld when 1 then 1 else 0 end as mybitfld,
myOtherColumns...
from myTable
group by case mybitfld when 1 then 1 else 0 end,
myOtherColumns...