sql 中变量名怎么改成动态公式获取？-灵析社区

1. 利用CONCAT和CURRENT_YEAR函数 SELECT '222' AS CONCAT(CURRENT_YEAR, '订货额') FROM DUMMY 2. 利用TO_VARCHAR 函数字符串拼接 SELECT '222' AS TO_VARCHAR(CURRENT_TIMESTAMP, 'YYYY') || '订货额' FROM DUMMY