如何显示谁的日期最多？比如max(count(max(date)))

jhdbpxl9 于 2021-06-18 发布在 Mysql

关注(0)|答案(1)|浏览(382)

我是这样想的：

SELECT l.vorname
     , l.nachname 
  FROM leser l 
  JOIN ausleihe a 
    ON l.LeserNr = a.LeserNr 
 WHERE MAX(COUNT(a.gemahnt)) = 
    (SELECT = COUNT(gemahnt) AS Anzahl 
       FROM ausleihe 
     WHERE Anzahl = (SELECT MAX(Anzahl)));

sql mysql Join Max inner-join

来源：https://stackoverflow.com/questions/53197305/how-do-i-show-the-name-who-has-the-most-dates-like-maxcountmaxdate

1条答案

按热度按时间

nom7f22z1#

SELECT 
l.Vorname, l.Nachname, COUNT(a.gemahnt) AS Anzahl
    FROM
leser l
    JOIN
ausleihe a ON l.LeserNr = a.LeserNr
   WHERE
a.gemahnt IS NOT NULL
GROUP BY a.LeserNr
HAVING Anzahl = (SELECT 
    COUNT(gemahnt)
FROM
    ausleihe
WHERE
    gemahnt IS NOT NULL
GROUP BY LeserNr
ORDER BY COUNT(gemahnt) DESC LIMIT 1);

：d个

赞(0）回复(0）举报 2021-06-18

我来回答

如何显示谁的日期最多？比如max(count(max(date)))

1条答案

相关问题

热门标签

最新问答