sql查询问题请找到解决方案 [英] sql Query issue please find the solution

问题描述

select * from  dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250

，输出为

and the output is

IE_VECHICLE_CODE UW_VEHICLE_CODE VEHICLE_MAKE_CODE VEHICLE_MODEL_CODE VEHICLE_SUBTYPE_CODE UW_CODE
1250	38162413	110	7	        72	6
1250	0	        84	12769	        0	11
1250	0	        3803	MARUTI SUZUKI	0	9

现在我想要uw_code = 6想要添加一个列并将'bajaj'放置为uw_code = 6



类似uw_code = 9是想要的添加一个列并为'uw_code = 9确定'tata'



等等怎么做





感谢您的支持



问候，



Rahul

now i want uw_code =6 is want add a column and place 'bajaj' for uw_code =6

similarly uw_code =9 is want add a column and place 'tata' for uw_code =9

and so on how to do this


Thanks in adv

Regards,

Rahul

推荐答案

我认为这将满足您的要求。

I think this will fulfill your requirement.

select *,case when uw_code =6 Then 'bajaj' when uw_code =9 then 'tata' End  as NewColumn from  dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250

试试此代码。

Try this code.

select IE_VECHICLE_CODE,UW_VEHICLE_CODE,VEHICLE_MAKE_CODE,VEHICLE_MODEL_CODEVEHICLE_SUBTYPE_CODE,
case
when UW_CODE = 6 then 'bajaj'
when UW_CODE = 9 then 'tata'
end as Company
from dbo.UW_VECHICLE_MAP where IE_VECHICLE_CODE=1250

这篇关于sql查询问题请找到解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！