title: Oracle query data base on TIME without show it to result
body: <p>I'm using <code>Oracle 11g</code>.</p>
  
  <p>I would like to sort my data based on <code>TIME ASC</code> but I don't want <code>TIME</code> show on result.</p>
  
  <p>Query</p>
  
  <pre><code>SELECT 
  DISTINCT
  D.DESCRIPTIONID, 
  D.DESCRIPTION,
  D.PROFILEID_FK AS PROFILEID_FKS,
  Y.PROFILEID_FK AS PROFILEID_FKS2,
  Y.TIME
  FROM 
  WA_BT_TBL_DESCRIPTION D
  LEFT OUTER JOIN WA_BT_TBL_DAY Y ON D.DESCRIPTIONID = Y.DESCRIPTIONID_FK
  WHERE
  D.PROFILEID_FK = 'PF0002' AND
  D.ACTIVE = 'Y'
  ORDER BY Y.TIME ASC
  </code></pre>
  
  <p>If I remove <code>Y.TIME</code>, it show me error</p>
  
  <pre><code>ORA-01791: not a SELECTed expression
  </code></pre>
  
  <p>Is there any way how to keep sort by <code>Y.TIME</code> without <code>Y.TIME</code> show on result?</p>
  
  <p>Let see on <a href="http://sqlfiddle.com/#!4/bf326/1" rel="nofollow noreferrer">SQL Fiddle</a></p>