what if i want the already existing table to be in a certain order? Acctually it is a table with a date column which used to be the PK before. Now i need a ID-column. How can i assure that ID is in the same order like the date-column (ascending or descending does not matter)?
many thanks for the first answer already. it was very helpful