方式一:order by primary key
方式二:order by 字段名1 ,字段名2
tables : spfli.
select * from spfli order by primary key.//按照关键字进行升序排列
write : / spfli-cityfrom.
endselect.
write : / '===================='.
select * from spfli order by cityfrom ascending
cityto descending.
write : / spfli-cityfrom.
endselect.