SELECT *
FROM passenger
WHERE (
SELECT COUNT(PassengerId) as total_passengers, Sex
FROM passenger
WHERE SibSp > 0
GROUP BY 2
ORDER BY 1)
我必須確定count of male or female我的資料集中是否有更多atleast 1 SibSp
當我執行子查詢時，我會根據需要獲得男性和女性計數。如何從子查詢中選擇最大計數？
請幫忙
uj5u.com熱心網友回復：
您不需要子查詢。只需使用分組查詢并添加 LIMIT 1 即可獲得具有最大計數的第一行。
SELECT Sex, COUNT(*) AS total_passengers
FROM passenger
WHERE SibSp > 0
GROUP BY Sex
ORDER BY total_passengers DESC
LIMIT 1
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/355527.html