如何合并到列上的colums值
问题描述：
大家好，
从VehicleMaster中选择CarID [ID]，CarName [Name]，CarNumber，其中CarStatus = 0
这是我的查询
我想合并到一列中的列值.我想在-"列上输入汽车号和汽车名称
hey guys,
select CarID [ID],CarName [Name],CarNumber from VehicleMaster where CarStatus=0
this is my query
i want to merge to column value in one column. i want to carnumber and carname in on column "-"
答
Try:
Try:
SELECT CarNumber + '-' + CarName AS [Name and number] FROM VehicleMaster
在Oracle中
=============
In Oracle
==============
select CarID [ID]||'-'||CarName [Name],CarNumber from VehicleMaster where CarStatus=0
在Sql
中
=======
in Sql
=======
select CarID [ID]+'-'+CarName [Name],CarNumber from VehicleMaster where CarStatus=0
从car master中选择carid，carnumber +''-''+ carname作为carstatus = 0的
select carid,carnumber +''-''+ carname as a from vehicle master where carstatus=0