mysql - 如何获取 MySQL 中嵌套查询和 WHERE IN 使用查询返回的行数？

Question

SELECT kullaniciNick,
       kullaniciAdi,
       kullaniciSoyadi
FROM panelkullanicilari
WHERE id IN
    (SELECT user_id
     FROM proje_ekip
     WHERE proje_id=11)
ORDER BY kullaniciSoyadi

在查询中我需要行数来检查它是否超过 6 或更少。当我使用 COUNT(*) 时，我收到一条错误消息。也就是说它必须与 GROUP BY 一起使用。谢谢。

Answer 1

试试这个:

SELECT kullaniciNick,
       kullaniciAdi,
       kullaniciSoyadi,
       count(*) -- Added this line
FROM panelkullanicilari
WHERE id IN
    (SELECT user_id
     FROM proje_ekip
     WHERE proje_id=11)
GROUP BY 1,2,3 -- Added this line
ORDER BY kullaniciSoyadi