title: TSQL Partition by with Order by
body: <p>I noticed that when I use a partition by like below</p>
  
  <pre><code>SELECT
  ROW_NUMBER() OVER(PARTITION BY categoryid
  ORDER BY unitprice, productid) AS rownum,
  categoryid, productid, productname, unitprice
  FROM Production.Products;
  </code></pre>
  
  <p>the result set returned to me accordingly in the proper partiton and order.</p>
  
  <p>Does that mean I do not have to provide an Order BY clause at the end to absolutely guarantee the order that I want?</p>
  
  <p>Thanks</p>