select fields from yourtable where 条件 order by 排序字段 into table xxx &&自由表
or
select fields from yourtable where 条件 order by 排序字段 into cursor xxx &&临时表只读
or
select fields from yourtable where 条件 order by 排序字段 into cursor xxx readwrite &&临时表可读写
如:
select d1,d2,d3,d4 from mytable where d1>100 order by d1 into cursor yourtable readwrite