List:General Discussion« Previous MessageNext Message »
From:Haluk Karamete Date:June 17 2012 2:19pm
Subject:distinct & count operation with the use of "where count > $num"
View as plain text  
Hi, I'm trying to get this work;

SELECT distinct `term`,count(*) as count FROM
blp_sql_distinct_temp_table where count >= 5 group by `term` order by
count DESC

But I get this error;

Unknown column 'count' in 'where clause'

How do I get only those records whose group by count is above 5?
Thread
distinct & count operation with the use of "where count > $num"Haluk Karamete17 Jun
  • Re: distinct & count operation with the use of "where count > $num"Tsubasa Tanaka17 Jun