title: Oracle : How to GROUP and ORDER in a single Query
body: <p>There is a table : FRUIT, the content :</p>
  
  <pre><code>NAME
  ------
  Banana
  Orange
  Orange
  Apple
  Banana
  Apple
  Apple
  Apple
  </code></pre>
  
  <p>I want result like this (Grouped and Ordered):</p>
  
  <pre><code>NAME
  ----
  Apple
  Banana
  Orange
  </code></pre>
  
  <p>I created a query :</p>
  
  <pre><code>SELECT NAME
  FROM FRUIT
  ORDER BY NAME
  GROUP BY NAME
  </code></pre>
  
  <p>I think it will run weel in MySql or Foxpro. But not in Oracle. How do I should the query like ? Thanks</p>