How do I get count to return 0 in SQL?
How do I get count to return 0 in SQL? COUNT() function It sets the number of rows or non NULL column values. COUNT() returns 0 if there were no matching rows. How do you make count 0 return instead of NULL? SELECT count(*) AS thecount FROM tablea WHERE cola…