SELECT orderid, orderdate, val, RANK() OVER(ORDER BY val DESC) AS rnk FROM Sales.OrderValues QUALIFY rnk <= 5;. 標準SQL沒用定義qualify子句,它是 ...
確定! 回上一頁