devxlogo

Descending index on SQL

Descending index on SQL

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.

devx-admin

Share the Post: