dalmat36 · March 11, 2014 15:29
diff --git a/RowNumber Function b/RowNumber Function
 /*ROW_NUMBER() Window function assigns
 unique incrementing integers to rows */
 SELECT orderid, custid, val, ROW_NUMBER() OVER (PARTITION BY custid ORDER BY val) AS rownum
 FROM Sales.OrderValues
 ORDER BY custid, val;
	/*ROW_NUMBER() Window function assigns
	unique incrementing integers to rows */
	SELECT orderid, custid, val, ROW_NUMBER() OVER (PARTITION BY custid ORDER BY val) AS rownum
	FROM Sales.OrderValues
	ORDER BY custid, val;