Calculate the difference between 2 Count


I’ve got sensor readings in my data table. They’re in the range of zero to five.

I want to calculate the difference between the number of values above 0 and the number of values = 0.

Is it possible to make the difference between these 2 counts?

“Select Count(value) from “test” where value > 0”.
“Select Count(value) from “test” where value = 0.”

Best regards,
Have a good day.

“select spread(count) from (select count(value) from test where value > 0),
(select count(value) from test where value = 0)”


1 Like