مرتب کردن جدول و قرار دادن در خودش

 

create table new as select * from oldtable order by field1

drop table oldtable

create table oldtable as select * from new order by field1

drop table new