我对MYSQL相当陌生!
我需要进行一个SQL查询,在其中检查一行有多少个喜欢(在两个表之间)
我发现了另一个看起来像我的问题,但我无法让它返回任何内容(即使它不会产生错误。
查询:
SELECT *
FROM likes
INNER JOIN (SELECT likes.like_id,
COUNT(*) AS likes
FROM likes
INNER JOIN uploads ON likes.upload_id=uploads.upload_id
WHERE uploads.upload_date >= DATE_SUB(CURDATE(), INTERVAL 8 DAY)
GROUP BY uploads.upload_id) x ON x.like_id = likes.like_id
ORDER BY x.likes DESC
链接到原始问题:MySQL,需要选择另一个表中具有最频繁值的行
非常感谢帮助
亲切问候马蒂亚斯
既然你没有发布你的表结构,我将不得不猜测..
select someid, count(*) cnt from
(
select * from table1 t1 join table2 t2 on t1.someid = t2.someid
) as q0 group by someid order by cnt desc;
它需要调整以适应您的架构。