SELECT
*
FROM
video a
LEFT JOIN
video b
ON a.colunm=b.colunm
AND a.id<b.id
WHERE
a.category='我们'
GROUP BY
a.id,
a.colunm
HAVING
*
FROM
video a
LEFT JOIN
video b
ON a.colunm=b.colunm
AND a.id<b.id
WHERE
a.category='我们'
GROUP BY
a.id,
a.colunm
HAVING
COUNT(b.colunm)<=10
注意,这样写在mysql可以写,但是使用hibernate会报错,应该使用a.id等形式