Sorting in descending order in SQL : <p>I have a table having customer name,  and their 2 ids- id 1 and id 2. Id2 is distinct for all customers but id1 is same for some of them. I want to sort the table in descending order on the basis of id 1.</p>

<p><code>SELECT * FROM table_name ORDER BY id1 DESC</code>
 works fine but same id1 should be sorted in descending order on the basis of their id2 value.</p>

<p>someone please help me how to achieve this.
thanks.</p>
