sql select查询 ,拼接字符串

select row_number() over(ORDER BY a.id DESC) as rowNumber,
   a.id,
   a.name,
   a.type_code,
   a.year,
   a.area+'万亩' as area,
   CASE WHEN a.name='绿色畜牧' THEN  a.yield+'头'
   ELSE a.yield+'万吨' END AS "yield",
   a.value+'万吨' as value,
   a.create_user,
   a.create_time,
   a.update_user,
   a.update_time
from ex_industry a

运行结果: