title: Do clustered index on a column GUARANTEES returning sorted rows according to that column
body: <p>I am unable to get clear cut answers on this contentious question .
  <a href="https://msdn.microsoft.com/en-us/library/ms190457.aspx" rel="nofollow noreferrer">MSDN documentation</a> mentions</p>
  
  <p>Clustered</p>
  
  <ul>
  <li><p>Clustered indexes <strong>sort</strong> and store the data rows in the table or view
  based on their key values. These are the columns included in the
  index definition. There can be only one clustered index per table,
  because the data rows themselves can be <strong>sorted</strong> in only one order.</p></li>
  <li><p>The only time the data rows in a table are stored in <strong>sorted</strong> order is
  when the table contains a clustered index. When a table has a
  clustered index, the table is called a clustered table. If a table
  has no clustered index, its data rows are stored in an unordered
  structure called a heap.</p></li>
  </ul>
  
  <p>While I see most of the answers</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/9584813/does-a-select-query-always-return-rows-in-the-same-order-table-with-clustered-i">Does a SELECT query always return rows in the same order? Table with clustered index</a></li>
  <li><a href="http://sqlwithmanoj.com/2013/06/02/clustered-index-do-not-guarantee-physically-ordering-or-sorting-of-rows/" rel="nofollow noreferrer">http://sqlwithmanoj.com/2013/06/02/clustered-index-do-not-guarantee-physically-ordering-or-sorting-of-rows/</a></li>
  </ul>
  
  <p>answering negative.</p>
  
  <p>What is it ?</p>