how to order of a column in a sql table with script code example

Example: sql alter table order by

ALTER TABLE tablename ORDER BY columnname ASC;.