1.mybatis中大小写判断
>为大于、<为小于
2.mysql中case运用
SELECT a.resulttime AS resulttime, a.vendor AS vendor, b.checktask AS sparefield2, CASE WHEN a.risk BETWEEN 0 AND 9 THEN '低' WHEN a.risk BETWEEN 10 AND 19 THEN '中' ELSE '高' END AS sparefield3, SUM(a.wrongcount) AS sparefield1 FROM at_checkriskresult a LEFT JOIN at_checkmethodresult b ON a.resulttime=b.checktime GROUP BY resulttime, vendor, sparefield3 |