Invalid query count

Question

I have a table whose structure is as follows:

id int userid int status enum ('pending','approved') dop datetime 

Data:

 id userid status dop 1 24 pending 2011-02-14 06:41:32 2 24 pending 2011-02-15 23:02:45 

When I run the following query:

 SELECT count( userid ) FROM t1 WHERE STATUS = 'pending' GROUP BY userid 

This gives me an account like “2,” which is wrong, can anyone tell me what is wrong here? and how to get a real account like 1

Answer 1

The group by statement is executed after the count. Use this instead:

 SELECT count( DISTINCT userid ) FROM t1 WHERE STATUS = 'pending' 

Answer 2

Do you want to count the number of users with pending status?

 SELECT count(userid) FROM t1 WHERE STATUS = 'pending' GROUP BY status, userid 

Answer 3

Try adding the user id in the select clause:

 SELECT userid, count( userid ) FROM t1 WHERE STATUS = 'pending' GROUP BY userid 

Answer 4

Maybe adding DISTINCT () to userid?

Answer 5

 SELECT count( DISTINCT userid ) FROM t1 WHERE STATUS = 'pending' GROUP BY userid 

Answer 6

You can use the COUNT (DISTINCT ()) construct, it allows you to read different non-NULL values ​​( document )

Try the following sentence:

 SELECT count( DISTINCT( userid ) ) FROM t1 WHERE STATUS = 'pending' GROUP BY userid 

NTN!