考研的題，，誰幫我瞅瞅
uj5u.com熱心網友回復：
select G.Sno, count(*) as cnt from Gjoin S on G.Sno=S.Sno
group by G.Sno
order by cnt desc
limit 1
uj5u.com熱心網友回復：
select Sno,count(*) from Sgroup by 1 order by 2 desc
LIMIT 1
uj5u.com熱心網友回復：
最多的學生有沒有可能有多個一樣的次數？uj5u.com熱心網友回復：
select Sno, count(*) as cnt from Ggroup by Sno
order by cnt desc
limit 1
如果存在多個次數一樣的學生的話，也只會篩選出一個而已
uj5u.com熱心網友回復：
若考慮最大值有多個可以使用下面語法SELECT
Sno, COUNT(Sno) AS cou
FROM
G
GROUP BY Sno
HAVING cou = (SELECT
COUNT(Sno) AS cou
FROM
G
GROUP BY Sno
ORDER BY cou DESC
LIMIT 1)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/31688.html
標籤：MySQL
下一篇：【求助】MSSQL資料庫合并