09 2022 档案
摘要:package com.gps808.inspect.controller; import com.framework.web.annotation.NotLogin; import com.framework.web.dto.AjaxResult; import com.gps808.inspec
阅读全文
摘要:1.GROUP BY分组统计分组中某个值的数量 SELECT SUM(CASE WHEN (address ='天津' AND is_retire = 1) THEN 1 ELSE 0 END) AS 天津退休人数 FROM USER GROUP BY 性别; 2.GROUP BY分组多个值分隔 ,
阅读全文