Kristoff1875
-
Posts
242 -
Joined
-
Last visited
Kristoff1875's Achievements
Member (2/5)
1
Reputation
-
I have a column called 'Progress' which updates as a row is processed. I have the following to count how many are in which stage: SELECT Progress, COUNT(*) AS counter FROM finished GROUP BY Progress Inside this I would also like to count where progress has the value of "1", but where there is a note added. So for example: SELECT * FROM finished WHERE Progress=1 AND notes != 0 Is it possible to check both of these things in the same query and group them separately?