title: Order by not working in Oracle subquery
body: <p>I'm trying to return 7 events from a table, from todays date, and have them in date order:</p>
  
  <pre><code>SELECT ID
  FROM table
   where ID in (select ID from table
  where DATEFIELD &gt;= trunc(sysdate)
  order by DATEFIELD ASC)
  and rownum &lt;= 7
  </code></pre>
  
  <p>If I remove the 'order by' it returns the IDs just fine and the query works, but it's not in the right order. Would appreciate any help with this since I can't seem to figure out what I'm doing wrong!</p>
  
  <p>(edit) for clarification, I was using this before, and the order returned was really out:</p>
  
  <pre><code>select ID
  from TABLE
  where DATEFIELD &gt;= trunc(sysdate)
  and rownum &lt;= 7
  order by DATEFIELD 
  </code></pre>
  
  <p>Thanks</p>