I want my Count() function to return 0 instead of nothing
When I do select Count(Somecolumns) from sometable between startdate and end date. and the the answer is 0, SQL does not return any rows. I want it to return with one row but value 0. How can I do that?