load数用的sql

select count(1) 
from orders_#t 
where substring(sendpay,24,1)<>'0' and parentid is null and createdate >= '2019-05-15 00:00:00' and createdate<='2019-05-15 18:00:00'
limit 1

 不等于用大于小于                                                  闭区间大于等于

select sum(totalPrice), sum(yun), sum(youhui), sum(totalServiceFee)
from orders_#t 
where substring(sendpay,24,1)<>'0' and parentid is null and createdate >= '2019-05-17 00:00:00' and createdate<='2019-05-17 18:00:00'

 

A+B-C-D