Count(case when)


#1


What is the purpose of the "THEN 1" portion of this code. This querey seems to yield the same results regardless of what follows the "THEN".


COUNT(CASE WHEN elevation <1000 THEN 1 ELSE NULL END)

Thanks!!


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.