mysql - 从具有 limit 和 desc 的 2 列中获取结果

Question

SELECT *
FROM VB_Names
WHERE Buurt = 'Spangen'
    AND Gender  = 'M'
    AND Gender  = 'V'
GROUP BY Name
ORDER BY COUNT DESC LIMIT 6

我想从性别“M”列中获得 3 个结果，从性别“V”列中获得 3 个结果，这两个结果都在 DESC 上计数。

Answer 1

性别不能在同一行中同时为“M”和“V”，因此此查询将不返回任何内容。相反，使用 union all:

(SELECT *
 FROM VB_Names
 WHERE Buurt = 'Spangen' AND Gender = 'M'
 ORDER BY count DESC
 LIMIT 3
) UNION ALL
(SELECT *
 FROM VB_Names
 WHERE Buurt = 'Spangen' AND Gender = 'V'
 ORDER BY count DESC
 LIMIT 3
)