Question:
How can I create an index in descending order? How can I order data in descending order with “Order By”? I’m using MS SQL Server 6.5.
Answer:
When you create the index, you don’t specify the order. However, on an “ORDER BY” clause you can specify the keyword DESC to obtain the result set in descending order.