“给 钱 排序”:order by:顺序,asc升序,desc降序
# desc:降序(大到小,高到低,后到先);
# asc升序(小到大,低到高,先到后);
# 默认asc升序小到大;asc可以不写默认
"给 钱 排序":order by:顺序
select *
from 表
order by 钱 asc;#默认asc升序小到大
select *
from 表
order by 钱 ;#默认升序可以不写asc
select *
from 表
order by 钱 desc ;#降序大到小
“按姓名长度和id编号排序”:
"按姓名长度和id编号排序":
select lenth(姓名) as 姓名长度,id编号
from 表
order by lenth(姓名) asc,id编号 desc;
select lenth(姓名) as 姓名长度,id编号
from 表
order by 姓名长度 desc,id编号;