摘要:
SELECT count(1) from energy_alarm_loss_info where hier_id = #{hierId} and date_type = #{dateType} <if test="dateType == '日'.toString()"> and date(crea 阅读全文
摘要:
-- 用FIND_IN_SET(state,'0,1,4,2,3,5,6') 可以按照指定的'0,1,4,2,3,5,6'状态进行排序 SELECT * FROM qua_prod_return ORDER BY FIND_IN_SET(state,'0,1,4,2,3,5,6'), prod_re 阅读全文