having count不起作用

[s781112]

SELECT * from video where category='我们' GROUP BY id,colunm having count(colunm)<4，我想按colunm分组后每个分组的数据不超过4条，但having count没起作用

[陈灬风]

你这个不是group by 的写法。SELECT id,colunm from video where category='我们' GROUP BY id,colunm having count(colunm)<4;

[阿健来了]

既然分组了肯定不能select *了

SELECT  id,colunm,count(1) from video where category='我们' GROUP BY id,colunm having count(1)<4

[卖水果的net]

mysql 的写法？ 说是 mysql 可以让没在 group by 中的字在，显示在 select 列表中。