I need number of records available for this status

SELECT process_status FROM sales where process_status = 0 and process_status = 1;

i need one mysql query how many process_status= 0 and how many process_status =1 i need individual count

how to write mysql query??

Try this:

SELECT process_status, COUNT(process_status) as num_process_status FROM sales GROUP BY process_status

i need number of record process_status= 0 then number of records process_status=1

Did you try the query I gave you? It will do that.

dude, you need some quiet time, to study SQL

i mean, if you’re going to keep using SQL, you should at least familiarize yourself with it a little bit

1 Like
ORDER BY process_status ASC

i need how to get the count process status wise


google it

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