title: SQL query to return any 100 rows quickly without scanning entire table
body: <p>I want to fire a SQL query that returns any 100 rows from the database table. I understand that using TOP (<code>SELECT TOP 100 * FROM TABLENAME</code>) makes the engine scan the entire table and then return results which might take quite some time for a huge table.</p>
  
  <p>Is there a SQL query to return any n rows without making engine to scan the entire table and/or to produce results quickly?</p>