数据库不一样,对应SQL写法略有差别;
这里以MYSQL为例:数据库排序需要依据逻辑,数字类型按照大小排序,字符按照对应编码规则排序
①关键加一个序列,也可以做一个序列维护表或者用编码
select tmp02.TDATE,tmp01.TNAME,tmp02.SALEAMOUNT,tmp01.code
from
(select '梨' as TNAME,1 as code
union all
select '葡萄' as TNAME,2 as code
union all
select '西瓜' as TNAME,3 as code
union all
select '橘子' as TNAME,4 as code
union all
select '柠檬' as TNAME,5 as code
union all
select '苹果' as TNAME,6 as code
union all
select '香蕉' as TNAME,7 as code) tmp01
left jion
(select TDATE,TNAME,SALEAMOUNT
from 表名) tmp02
on tmp01.TNAME=tmp02.TNAME
order by code, SALEAMOUNT desc
②这个容易,按照日期group by之后,左关联汇总即可