SELECT COUNT(CHARGE_TYPE),CHARGE_TYPE,ORDER_ID,CREATE_TIME FROM bal_order_charge WHERE CHARGE_TYPE='315' GROUP BY ORDER_ID
HAVING COUNT(CHARGE_TYPE)>1 ;
service:jmx:rmi://52.74.7.254:10002/jndi/rmi://52.74.7.254:10001/jmxrmi
admin/ecms
SELECT COUNT(CHARGE_TYPE),CHARGE_TYPE,ORDER_ID,CREATE_TIME FROM bal_order_charge WHERE CHARGE_TYPE='315' GROUP BY ORDER_ID
HAVING COUNT(CHARGE_TYPE)>1 ;
service:jmx:rmi://52.74.7.254:10002/jndi/rmi://52.74.7.254:10001/jmxrmi
admin/ecms
转载于:https://my.oschina.net/darrenshi/blog/834941