title: ORA-00907: missing right parenthesis in Select query
body: <p>This is the table
  <strong>City</strong></p>
  <pre><code>Def
  Abc
  Ijkl
  Mnop
  </code></pre>
  <p>And
  I want the output, where the smallest city name is returned, who have same number of characters.
  OUTPUT</p>
  <pre><code>Abc 3
  Ijkl 4
  </code></pre>
  <p>Notice that there were 2 cities with same number of characters Abc and Def, and only Abc will be returned.</p>
  <p>The Oracle SQL query which i am trying to run is -</p>
  <pre><code>Select a.city,a.leng from
  (
  Select city,length(city) as leng from station 
  order by 2,1
  ) as a where a.leng in (
  Select distinct(length(city)) from station 
  order by 1);
  </code></pre>
  <p>I hope there will be numerous ways to solve but i want to correct my approach.</p>