Monday, 15 July 2013

select - MySQL: how to get records with count > 1? -


I have one such SQL:

  SELECT *, count (*) cc Support by several groups, with help in the form, the bid order  

by CC DESC returns all records with # count.

However, what can I do if I want to achieve only> with counting 1? Select

 , count (*) from cc with manytomany support group, Spoken 1 & lt; Count (*) order by CC DESC  

No comments:

Post a Comment