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

SELECT '222' AS "2023订货额" FROM DUMMY 变量名 2023订货额中的2023 怎么改成取当前年年份，sql该怎么写

阅读量：11

点赞量：0

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