order by

1

select username from user order by age;

按多个列排序

1

select username from user order by age, weight, username;

先按age进行排序，age相同则按weight排序，age、weight都相同，则按username进行排序

指定排序方向

  • desc(从高到低)
  • asc（从低到高）
1

select username from user order by username desc;