1、查询该字段出现一次的
select count(MACHINE_ID) ,MACHINE_ID from t_ratio group by MACHINE_ID having count(MACHINE_ID)=1
2、查询
SELECT COALESCE(SUM(TOTAL_FEE),0) as dateMoney,count(*) as orderNum,COALESCE(SUM(TOTAL_PLAY_NO),0) as openNum FROM t_order where PAY_TIME>=1493136000 AND
PAY_TIME<=1493222400 AND ORDER_STATE = 1 AND MACHINE_ID='MA0041'