将以下sql语句转换为mybatis的xml SELECT nwind_direction_group from SELECT CASE WHEN wind_direction = 0 AND wind_direction 90 THEN 东北风 WHEN wind_direction = 90 AND wind_direction 180 THEN

• 日期: 2028-11-28
• 标签: 社会

SELECT n.wind_direction_group FROM ( SELECT CASE WHEN wind_direction >= 0 AND wind_direction < 90 THEN '东北风' WHEN wind_direction >= 90 AND wind_direction < 180 THEN '西北风' WHEN wind_direction >= 180 AND wind_direction < 270 THEN '西南风' WHEN wind_direction >= 270 AND wind_direction <= 360 THEN '东南风' END AS wind_direction_group, COUNT(*) AS cnt FROM `pmis-dtu`.environment_info WHERE MONTH(date_time) = MONTH(CURDATE()) AND YEAR(date_time) = YEAR(CURDATE()) GROUP BY wind_direction_group ) n ORDER BY cnt DESC LIMIT 1;

原文地址: https://www.cveoy.top/t/topic/bhb4 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录