title: SQL to have one specific record at the top, all others below
body: <p>I am trying to put together a query that will display one specific record (found by the record's primary ID) at the top, and display all other records below it, sorted by date (I have "date_added" as one of the fields in the table, in addition to primary ID).</p>
  
  <p>I could do this with a UNION (first select would locate the record I want, and the other select would display all other records), but I'm wondering if is there perhaps a better way?</p>
  
  <p>I'm using Oracle, by the way.</p>