我有 1 張桌子和 4 列。我想從訪問和消費中獲得最大價值，使用條件是最大訪問第一和最大消費第二。
結果應顯示在上圖中的黃色突出顯示。
對于我下面的代碼。請以更好的方式幫助我做到這一點。
select tt.*
from #max_location as tt,
(select member_number,
max(max_visit) as maxvisit,
max(spending) as maxspending
from #max_location
group by member_number) as max_visit
where tt.member_number = max_visit.member_number
and tt.max_visit = max_visit.maxvisit
and tt.spending = max_visit.maxspending
order by tt.member_number desc
uj5u.com熱心網友回復：
這將是撰寫查詢的 ANSI/ISO SQL 方式：
select tt.*
from #max_location tt
join (
select member_number,
max(max_visit) as max_visit,
max(spending) as max_spending
from #max_location
group by member_number
) as mv on mv.member_number = tt.member_number
and mv.max_visit = tt.max_visit
and mv.max_spending = tt.spending
order by tt.member_number desc
uj5u.com熱心網友回復：
SELECT member_number,
MAX(max_visit) AS maxvisit,
MAX(spending) AS maxspending
FROM #max_location
GROUP BY member_number
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/443362.html