最佳答案:哪种数据库?
如果是sqlserver: select cast(column1 as varchar(10)) + '-' + cast(column2 as varchar(10)
哪种数据库? 如果是sqlserver: select cast(column1 as varchar(10)) + '-' + cast(column2 as varchar(10) ...) as p from table 这么一直拼就好了。 如果是oracle: select to_char(column1) || '-' || to_char(column1)|| '-' || to_char... as p from table