TO_CHAR(gather_time, ‘dd/mm’) ：to_char(待转换值,转换格式) concat_ws(’’,bridge_name,‘高度’) ：concat_ws（）拼接字符串
select concat_ws('',bridge_name,'高度') bridge_name,"bridge_hight","hight_warning",bridge_breadth, case when "bridge_breadth" < "hight_warning" then '正常' else '异常' end statusBar from hydrological_navigable_road_bridge <where> "bridge_name" in ('xxx','xxx'', 'xxx','xxx'','xxx'') </where>