OVER 子句 (Transact-SQL)

collation_name 可以是 Windows 定序名稱或 SQL 定序名稱。 如需詳細資訊，請參閱＜ 定序與 Unicode 支援 ＞。 COLLATE 只適用於 ... (PARTITION BY SalesOrderID) AS "Avg" ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS "Count" ,MIN 複製 ...

msdn.microsoft.com