Yep there's lots of variations:

SELECT 'One row', SUM(CASE WHEN 1 = 0 THEN 0 ELSE 1 END)

WHERE 1 = 0;