2017-01-30から1日間の記事一覧
11行目~20行目のサンプル USE AdventureWorks2012; GO SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS RN , FirstName , LastName , ROUND(SalesYTD, 2, 1) AS “Sales YTD” FROM Sales.vSalesPerson WHERE TerritoryName IS NOT NUL…