[SOLVED] Count with a where clause

[nathanblogs]

hey,

 

I am trying to make a SQL statement that will allow me to select only group members that appear multiple times in a table. This is my current sql statement:

 

SELECT *, count(grpmem_peopleid) AS num FROM group_members
WHERE num > 1
GROUP BY grpmem_peopleid
ORDER BY num DESC 

 

my current error is this:

 

Unknown column 'num' in 'where clause'

[rajivgonsalves]

try this statment instead

 

SELECT count(grpmem_peopleid) AS num ,* FROM group_members
GROUP BY grpmem_peopleid having count(*) > 1
ORDER BY num DESC 

[nathanblogs]

Works a charm thanks