分组显示订单总数和交易成功订单数SELECTord.ORDER_TYPEas订单类型,COUNT(ord.ORDER_ID)as订单总数,orde.succCountas交易成功订单总数FROMORDERordLEFTJOIN(SELECTORDER_TYPE,COUNT(ORDER_ID)ASsuccCountFROMORDERWHERESTATUS_ID=’ORDER_SUCCESS’GROUPBYORDER_TYPE)ordeONorde.ORDER_TYPE=ord.ORDER_TYPEGROUPBYord.ORDER_TYPE;还有一种方法是，SELECTORDER_TYPEAS订单类型,STATUS_IDAS订单状态,COUNT(ORDER_ID)AS订单数FROMORDERGROUPBYORDER_TYPE,STATUS_ID;查出以订单类型的不同状态为分组的订单数，然后在代码中求订单总数