Database Sort permanent

Database
Enthusiast

Database Sort permanent

I created my tables and loaded my data from Excel into my Teradata tables. I noticed that it did not load as the Excel was laid out with 1, 2, 3, 4, etc. When I open the first table, it has 4, 1, 2, 3 etc. I want to make it so the table always has 1 first and is in ascending order based on the PK. Is there a way to run an update query and do this?

1 REPLY
Enthusiast

Re: Database Sort permanent

You'll need to order it when you select from it. Teradata does not store the data in order.

Just sel cols.. order by col(desc,asc)