sql
咖啡❤不甜
这个作者很懒,什么都没留下…
展开
-
group by分组取某字段最大值
select a.* from (select er.pkid,sb.fullName as 'modificationeName',er.month,er.sample_begintime,er.sample_endtime,er.coefficient,er.modificationTime,er.forecast_value, ifnull(er.value,0) as 'value',ifnull(er.ratio,0) as 'ratio' from energyfore.原创 2020-10-29 11:21:52 · 895 阅读 · 0 评论 -
if test 字符串判断
写法例子 <if test="dateNoLimit == 'N'.toString()"> xxx </if>原创 2020-10-29 11:17:37 · 460 阅读 · 0 评论