title: query a query result , return only TOP 100 rows
body: <p>I start a query on an MSSQL Server with the following statement </p>
  
  <pre><code>aquery.sql.text := ' select * from Mytable where &lt;XXXXXXXXXXXXXXXXXXX&gt;';
  aquery.open; 
  repeat 
     //........
  until aquery.EOF
  </code></pre>
  
  <p>MyTable has 4 additional col#s :    x1,x2,y1,y2;
  I want to get from above SQL Statement only the top 100 row's, but they should be rows with Maximum  Area, which means (area = abs(x1-x0) * abs(y1-y0);</p>
  
  <p>What is the best solution to get only 100 records with a Maximum area, but limited with the given Basic SQL Statement ?</p>