sql 时间函数用法

最新推荐文章于 2023-12-05 20:17:51 发布

转载最新推荐文章于 2023-12-05 20:17:51 发布 · 81 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/baijin05/p/5040351.html

IF(g.give_integral > -1, g.give_integral, c.goods_price)
这个函数的结果要根据g.give_integral的值，如果g.give_integral大于-1函数值就是g.give_integral，否则函数值就是c.goods_price。

SELECT COUNT(r.created_by) AS sa_num,ss.truename,ss.id,
(SELECT COUNT(1) FROM store_sequence_statue WHERE paycar='0' AND r.customerid='3040000100000000002' AND STR_TO_DATE(r.created_time,'%Y-%m-%d') BETWEEN '2015-09-13' AND '2015-09-15') AS ontime_car,
(SELECT COUNT(1) FROM store_sequence_statue WHERE paycar='1' AND r.customerid='3040000100000000002' AND STR_TO_DATE(r.created_time,'%Y-%m-%d') BETWEEN '2015-09-13' AND '2015-09-15') AS notime_car,
(IF(COUNT(r.created_by)=0,0,(SELECT COUNT(1) FROM store_sequence_statue WHERE paycar='0' AND r.customerid='3040000100000000002' AND STR_TO_DATE(r.created_time,'%Y-%m-%d') BETWEEN '2015-09-13' AND '2015-09-15')/COUNT(r.created_by))) AS shulv
FROM store_repair r INNER JOIN sys_admin ss ON ss.id=r.created_by WHERE r.customerid ='3040000100000000002' AND STR_TO_DATE(r.created_time,'%Y-%m-%d') BETWEEN '2015-09-13' AND '2015-09-15' GROUP BY r.created_by

转载于:https://www.cnblogs.com/baijin05/p/5040351.html