How to sort id records of data in a table of SQL Server from high to low
<p>I have a problem to sort data by ID, I tried <code>order by ASC</code> and <code>DESC</code> but none of them did what I need.</p>

<p>Normally records registered into table from low to high, for example:</p>

<pre><code>ID   column1     column2 
-------------------------
1    test1        test1
2    test2        test2
3    test3        test3
</code></pre>

<p>but I would like to records data to tables from high to low as follow </p>

<pre><code>ID   column1     column2 
-------------------------
3    test1        test1
2    test2        test2
1    test3        test3
</code></pre>

<p>your help would be appreciated.</p>

<p>As I said I would like to see the records in table of database from high to low.</p>