有没有办法调整以下MYSQL查询,使其仅显示视频计数大于0的结果?我尝试了以下方法,但它无法识别标签。
SELECT channels.*,
(SELECT COUNT(*) FROM videos WHERE videos.video_publisher_id = channels.channel_id) as `video_count`
FROM channels
WHERE channel_active = 1
AND video_count > 0
AND channel_thumbnail IS NOT NULL
ORDER BY channel_subscribers DESC
having_by
子句。 - NikuNj Rathodhavin_by
做什么? - underscore_d