1、升序排列
create index ix_table1 on table1 (column1,column2);
select column1,column2 from table1 order by column1,column2;
2、降序排列
create index ix_table1 on table1 (column1 desc,column2);
select column1,column2 from table1 order by column1 desc,column2;
本文共 249 字，大约阅读时间需要 1 分钟。
1、升序排列
create index ix_table1 on table1 (column1,column2);
select column1,column2 from table1 order by column1,column2;
2、降序排列
create index ix_table1 on table1 (column1 desc,column2);
select column1,column2 from table1 order by column1 desc,column2;
转载地址：http://afnlx.baihongyu.com/