我现在要做和SQL Server提供的select case 语句的功能,不知道Access是否支持?
怎么才能解决这个问题呢?回答者有分
如:
select (case when Column1='1' then '壹' else Column1 end) as NewColumn
from TableName
...全文
8813打赏收藏
用过Access的过来帮帮忙,回答一个简单SQL问题
我现在要做和SQL Server提供的select case 语句的功能,不知道Access是否支持? 怎么才能解决这个问题呢?回答者有分 如: select (case when Column1='1' then '壹' else Column1 end) as NewColumn from TableName
select (case when [报纸名称]='新闻报' and [备注] like '*晨*' then '新闻晨报'
when [报纸名称]='新闻报' and [备注] like '*午*' then '新闻午报'
when [报纸名称]='新闻报' and [备注] like '*晚*' then '新闻晚报'
else [报纸名称] end) as BZMC,sum([广告费]) from TableGG group by BZMC
select iif(when [报纸名称]='新闻报' and [备注] like '*晨*' , '新闻晨报' ,
iif( when [报纸名称]='新闻报' and [备注] like '*午*' ,'新闻午报',
iif( when [报纸名称]='新闻报' and [备注] like '*晚*' , '新闻晚报'
, [报纸名称] ))) as BZMC,sum([广告费]) from TableGG group by BZMC