Alex Rivera | Logout

MySQL - Using COUNT(*) in the WHERE clause

Asked 2008-11-19T12:47:36.213
210

I am trying to accomplish the following in MySQL (see pseudo code)

SELECT DISTINCT gid
FROM `gd`
WHERE COUNT(*) > 10
ORDER BY lastupdated DESC

Is there a way to do this without using a (SELECT...) in the WHERE clause because that would seem like a waste of resources.

mysql count aggregation having
Edit
Report

1 Answer

0

i think you can not add count() with where. now see why ....

where is not same as having , having means you are working or dealing with group and same work of count , it is also dealing with the whole group ,

now how count it is working as whole group

create a table and enter some id's and then use: 

select count(*) from table_name

you will find the total values means it is indicating some group ! so where does added with count() ;

answered 2012-04-05T06:32:27.480

Your Answer