sql两列的查询合并到一个里面

2025-01-19 16:11:33
推荐回答(2个)
回答1:

select rtrim(cast(s_daymin as char(20)) + '-' + rtrim(cast(s_daymax as char(20))
from 表

回答2:

s_daymin || ‘-’ || s_daymax