insert data in table in descending order

Question

i want to insert values in table descending order . like 5 4 3 2 1 means if new row inserted in table then 6 5 4 3 2 1. please tell me fast

Wim Sturkenboom · Answer

What kind of table? Datatable database table ... Inserting in a given sequence in a database table does NOT guarantee that they are retrieved in that order. You can use the solution with clustered index above or the solution above with the 'order by' clause. for what you want to achieve I'll prefer the latter as it guarantees consistency (in case you later decide to modify the index).

Riddhi Valecha · Answer

Hi.. The data will remain in back-end (say sql table). While displaying just write order by clause in descending order.

Vikram Agrawal · Answer

Hi Priya You can do it with the help of indexes To do this you have to create one clustered index on your table follow the below example CREATE CLUSTERED INDEX [IndexName] ON [TableName] ( [IDColumnName] ) now whenever you select records from the table then it will automatic arranges in descending order

Dipankar Biswas · Answer

see here.. http://www.guru99.com/order-by-desc-and-asc.html