Retrieve different data from one column in MySQL

QuestionsRetrieve different data from one column in MySQL
sethbeckerman5 Staff asked 4 years ago

Suppose a table have a column with values like:

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:

Thanks in advance.


View on Stack Overflow