-- SQL Server COUNT aggregate function over partition by -- MSSQL windowing functions USE AdventureWorks; SELECT PO = PurchaseOrderID, VendorID, ShipDate ...
www.sqlusa.com