You may use ROW_NUMBER along with a CASE expression to identify the latest year and quarter.WITH cte AS ( SELECT uid, year, quarter, AVG(earned) AS avg_earned, ROW_NUMBER() OVER (PARTITION BY uid ORDER BY year DESC, CASE quarter WHEN 'f' THEN 3 WHEN 's' THEN 2 WHEN 'w' THEN 1 END DESC) rn FROM income GROUP BY uid, year, quarter)SELECT uid, year, quarter, avg_earnedFROM cteWHERE rn = 1;演示 这篇关于我们可以通过嵌套组获得每个用户的最新可用平均季度收入吗?sqlite的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-19 12:44
查看更多