<blockquote>
  <p><strong>Possible Duplicate:</strong><br>
  <a href="https://stackoverflow.com/questions/311054/how-do-i-select-last-5-rows-in-a-table-without-sorting">How do I select last 5 rows in a table without sorting?</a>  </p>
</blockquote>



<p>I want to select the top 10 records from a table in SQL Server without arranging the table in ascending or descending order.</p>

if random order is needed, you can try
```
```
select top 10 * from [tablename] order by newid()
```
```