SQL alter table to order by code example

Example: sql alter table order by

ALTER TABLE tablename ORDER BY columnname ASC;.