主页 / 问题 / 940258
Accepted
Roman
Asked:2020-02-03 23:09:31 +0800 CST2020-02-03 23:09:31 +0800 CST

SQL MAX() 多个值

  • 772

有这样一个请求：

    SELECT name, MAX(SkillsCount) 
    FROM (SELECT Users.name, Users.id, COUNT(Skills.SkillName) as SkillsCount
        FROM Users join Skills on Users.id == Skills.id
        GROUP BY Users.id)

但是，它只输出一个值，虽然有几个值具有相同的 SkillsCount (5)

sql

1 个回答

  1. Best Answer

    像这样的东西：

    WITH counts AS (SELECT Users.name, Users.id, COUNT(Skills.SkillName) as SkillsCount
     FROM Users join Skills on Users.id == Skills.id
     GROUP BY Users.id)
SELECT name, SkillsCount
  FROM counts
  WHERE SkillsCount=(SELECT MAX(SkillsCount) FROM counts);

    但是为了在大型表上获得不错的性能，您必须进行修补。

    • 0

相关问题