How to query more select statment from the same table and the same column ?

[Jason4Ever]

hi

i have one table and it's contain column with name 'status' , i want do sql command to fetch total number of rows , and total number of rows which it's value = 1 and total number of rows which it's value = 0 , i tried to do it using join , but's it's result 2 results ! not one , so plz help me with true command

[swampBoogie]

select count(*),
         sum(case when status = 1 then 1 else 0 end),
         sum(case when status = 0 then 1 else 0 end)
  from t

[Jason4Ever]

thanks alot , but you didn't use count instead of sum ?

[r937]

SELECT COUNT(*) AS all
     , COUNT(CASE WHEN status = 1 THEN 937 ELSE NULL END) AS ones
     , COUNT(CASE WHEN status = 0 THEN 937 ELSE NULL END) AS zeroes
  FROM daTable