如何合并到列上的colums值 [英] how to merge to colums value in on column

问题描述

大家好，

从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

这篇关于如何合并到列上的colums值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！