title: SQL best practice to deal with default sort order
body: <p>A lot of SQL code I've read, it seems like the developer assumes that the default sort order always holds.  For example when building an HTML select list they would just <code>SELECT id, name FROM table</code> without issuing an <code>ORDER BY</code> clause.</p>
  
  <p>From my own experience it seems like dbms alway orders data using FIFO if no <code>ORDER BY</code> clause is given and no index.  However, the order is not guaranteed.  But I have never seen a dbms reordering data if there no change to the table.</p>
  
  <p>Have you ever experienced a dbms selecting data in a non deterministic order if there is no change to the table?</p>
  
  <p>Is it best practice to always put an ORDER BY clause?  </p>