title: How to fetch top ten rows of different tables in oracle?
body: <p>I have 4 tables which have 5 columns in common. I want to fetch the latest overall top ten rows for these tables, and retrieve them.<br>
  How can i do that?
  I tried using a simple join command, but instead of 5 columns I get 20 columns! each table has its own column name alias! but what I want is, to have a 5 column table which contains all of those top 10s.  </p>
  
  <p>Update:</p>
  
  <pre><code>fetch FIRST 10 ROWS ONLY 
  </code></pre>
  
  <p>Command returns the 10 first records, not the latest ones
  when I run the following command for example :</p>
  
  <pre><code>select * from tblTest order by ID FETCH First 3 ROWS Only;
  </code></pre>
  
  <p>I get </p>
  
  <pre><code>1 Ali
  2 Jacob
  3 Chris
  </code></pre>
  
  <p>Where I actually needed </p>
  
  <pre><code>18 Fatima
  19 Mary
  20 Catherina
  </code></pre>
  
  <p>How can i achieve such a thing?</p>