Power BIで順位表を作る方法　Rank関数への誘い - ソフ蔵（ソフゾウ）

Overview of SQL RANK functions

11. Write a SELECT statement that uses the ranking functions to rank products by thetotal quantity sold. Return these columns:The productname column from the Products tableA column named totalquantity that shows the sum of the quantity foreach product in the OrderItems tableA column named rank that uses the RANK function to rank the totalquantity in descending sequenceA column named denserank that uses the DENSERANK function torank the total quantity in descending sequence12. Write a SELECT stat

SQL Aggregate Functions Code Samples

SQL Server MAX() aggregate function

The Ultimate Guide to SQL Window Functions