dalmat36 · August 29, 2015 13:57
diff --git a/ROW_NUMBER b/ROW_NUMBER
 /*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;
diff --git a/TSQL Fundamentals 2012 CH2 b/TSQL Fundamentals 2012 CH2
 stuff
	/*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;