As trying to make a condition inside an SQL where clause based on the COUNT function or other functions, the trivial one is to use :

SELECT count(items) as cnt from user_items where cnt>3

This is not going to work, and therefore you need to use the following one instead :

SELECT count(items) as cnt from user_items having count(items)>3

In case you want to add a where clause to the SQL statement, here is how it should look :

SELECT count(items) as cnt from user_items where id>1000 having count(items)>3

This entry was posted on Monday, December 8th, 2008 at 4:53 am and is filed under Programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.