急在线等待！，高手请进！SQL问题

gq198718 2010-12-10 02:26:11

SELECT Guid, ContractName, ContractPaths, UpLoadTime, UpLoadPeople, TreatmentTime, TreatmentAdmin, IsDelete ,ReferencePrice = case when ModifyState is 0 then '未处理' case when ModifyState is 1 then '同意' else '拒绝' end , FROM db_Contract WHERE 0 =0 AND UpLoadPeople = 'dddd' AND IsDelete = 0 ORDER BY UpLoadTime

...全文

63 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

gq198718 2010-12-10

打赏
举报

晕怎么不能结贴

gq198718 2010-12-10

打赏
举报

谢谢4楼 OK了！

水妹妹 2010-12-10

打赏
举报

SELECT Guid, ContractName, ContractPaths, UpLoadTime, 

UpLoadPeople, TreatmentTime, TreatmentAdmin, 

IsDelete ,

ReferencePrice = case when ModifyState=0 

then '未处理' 

 when ModifyState=1 then '同意' else '拒绝' end  

FROM db_Contract 

WHERE 0 =0 AND UpLoadPeople = 'dddd' AND IsDelete = 0 

ORDER BY UpLoadTime

gq198718 2010-12-10

打赏
举报

谢谢回答我试试

水族杰纶 2010-12-10

打赏
举报

SELECT [Guid], 

       ContractName, 

       ContractPaths, 

       UpLoadTime, 

       UpLoadPeople, 

       TreatmentTime, 

       TreatmentAdmin, 

       IsDelete ,

      ReferencePrice = case when ModifyState=0 then '未处理' when ModifyState=1 then '同意' else '拒绝' end 

 FROM db_Contract 

WHERE 0 =0 AND UpLoadPeople = 'dddd' AND IsDelete = 0 ORDER BY UpLoadTime

王向飞 2010-12-10

打赏
举报

SELECT Guid, ContractName, ContractPaths, UpLoadTime, UpLoadPeople, 

TreatmentTime, TreatmentAdmin, IsDelete ,

case when ModifyState is 0 then '未处理' 

 when ModifyState is 1 then '同意' else '拒绝' end  as ReferencePrice , 

FROM db_Contract 

WHERE 0 =0 AND UpLoadPeople = 'dddd' AND IsDelete = 0 

ORDER BY UpLoadTime

gq198718 2010-12-10

打赏
举报

是这样的
SELECT Guid, ContractName, ContractPaths, UpLoadTime, UpLoadPeople, TreatmentTime, TreatmentAdmin, IsDelete ,ModifyState = case when ModifyState is 0 then '未处理' case when ModifyState is 1 then '同意' else '拒绝' end , FROM db_Contract WHERE 0 =0 AND UpLoadPeople = 'dddd' AND IsDelete = 0 ORDER BY UpLoadTime