mysql 多语句cha询排序问题

917622157

SELECT SUM(SL),sum(BL) FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-08'
UNION
SELECT SUM(SL),sum(BL) FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-09'
UNION
SELECT SUM(SL),sum(BL)FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-10'


如上 返回的求和结果如何才能 排序

精易小鱼

1. SELECT * FROM (
   
2. SELECT SUM(SL),sum(BL) FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-08'
   
3. UNION
   
4. SELECT SUM(SL),sum(BL) FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-09'
   
5. UNION
   
6. SELECT SUM(SL),sum(BL)FROM `cl1` WHERE `xh`='45加长'AND LEFT(`rq`,7)='2020-10'
   
7. ) AS a ORDER BY `通过哪个值来排序` DESC;

复制代码

917622157

精易小鱼 发表于 2020-10-15 21:07

SUM(SL)  用这个值排序怎么写

917622157

精易小鱼 发表于 2020-10-15 21:07

SELECT *
FROM (

SELECT SUM( SL ) AS ks, sum( BL )
FROM `cl1`
WHERE `xh` = '45加长'
AND LEFT( `rq` , 7 ) = '2020-08'
UNION
SELECT SUM( SL ) AS ks, sum( BL )
FROM `cl1`
WHERE `xh` = '45加长'
AND LEFT( `rq` , 7 ) = '2020-09'
UNION
SELECT SUM( SL ) AS ks, sum( BL )
FROM `cl1`
WHERE `xh` = '45加长'
AND LEFT( `rq` , 7 ) = '2020-10'
) AS a
ORDER BY `ks` DESC