数据分析师的SQL功底该学到什么程度?
复制selecttop(100) *
from ( select
OrderId
, OrderMonth
, OrderAmount
, Row_Number() Over(
OrderBy OrderAmount DESC)
AS Amt_Order
from FctSales) tmp
Where Amt_Order between 2000 and 3000
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.
THE END