Suppose a table have a column with values like:
column
3
1
1
3
4
1
2
I want to retrieve that how many times there is 1 in column and how many times > 1.
Is there anyway to do this within one query?
I want the data to be fetched like this:
one | greater_than_one
3 | 4
Thanks in advance.
>Solution :
Simple:
select sum(col1=1) as one ,
sum(col1>1) as greater_than_one
from test_tbl;