一个很困惑的问题

zhuyiwen

1. 
   
2. SELECT s.CONSIGNEE, SUM(s.TEU) AS TEU, s.TRADE, s.[P/C]
   
3. FROM (
   
4.     SELECT *   
   
5.     FROM SHEET1
   
6.     WHERE [P/C] = 'C' and TRADE='AEX'
   
7.     ORDER BY CONSIGNEE DESC
   
8. ) s
   
9. GROUP BY s.CONSIGNEE, s.TRADE, s.[P/C]
   
10. ORDER BY SUM(s.TEU) DESC;
    

复制代码