Re: Count

[brian <brian(at)zijn-digital(dot)com>]

Bob Pawley wrote:
> I have a table with four columns that will either be null or hold the 
> value 'true'.

Any reason why the NULL values aren't instead FALSE? NULL != FALSE.

> I want to obtain the count of these columns, within a particular row, 
> that have 'true' as a value (0 to 4).

SELECT
    (CASE WHEN t.col1 = TRUE THEN 1 ELSE 0 END)
  + (CASE WHEN t.col2 = TRUE THEN 1 ELSE 0 END)
  + (CASE WHEN t.col3 = TRUE THEN 1 ELSE 0 END)
  + (CASE WHEN t.col4 = TRUE THEN 1 ELSE 0 END)
AS true_count FROM your_table AS t;

I'm sure there's a more clever way than that, though.

> I have attempted the Select count method but it seems that I need 
> something more.

That would only be useful if you were counting across rows (aggregating).

b