本笔记为阿里云天池龙珠计划SQL训练营的学习内容,链接为:https://tianchi.aliyun.com/specials/promotion/aicampsql;
<窗口函数> OVER ([PARTITION BY <列名>] ORDER BY <排序用列名>)
SELECT product_name, product_type, sale_price, RANK() OVER (PARTITION BY product_type ORDER BY sale_price) AS ranking
FROM product
窗口函数种类:专用函数(RANK、DENSE_RANK、ROW_NUMBER)和聚合函数(求值)