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

COUNT() with GROUP BY

google it

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