单个字段降序排序:
select * from tableA order by id desc;
单个字段升序排序:
select * from ableA order by id asc;
多个字段排序:
select * from ableA order by id desc,name desc;
【格式】order by 字段1 排序方式1, 字段2 排序方式2
单个字段降序排序:
select * from tableA order by id desc;
单个字段升序排序:
select * from ableA order by id asc;
多个字段排序:
select * from ableA order by id desc,name desc;
【格式】order by 字段1 排序方式1, 字段2 排序方式2