＋设为首页 ＋添加到收藏夹
1,select left(Region,1) as RegionName,
count(distinct Region) as aaa
from moneyinfo
where
Region like %贷%
group by left(Region,1)
2,select left(Region,1) as RegionName,
count(distinct(Region)) as bbb
from moneyinfo
where
right(left(Region,2),1) <> 贷
group by left(Region,1)
如何在where前用case when的形式写啊？
我不知道distinct该放哪，老报distinct附近有语法错误
select left(Region,1) as RegionName,
count(distinct Region) as aaa
from moneyinfo
where
Region like %贷%
group by left(Region,1)
Union All --加上这个
select left(Region,1) as RegionName,
count(distinct(Region)) as bbb
from moneyinfo
where
right(left(Region,2),1) <> 贷
group by left(Region,1)
用(select 语句) union (select 语句)
eg:
select left(Region,1) as RegionName,
count(distinct Region) as aaa,
as bbb
from moneyinfo
where
Region like %贷%
group by left(Region,1)
union
lect left(Region,1) as RegionName,
as aaa,
count(distinct(Region)) as bbb
from moneyinfo
where
right(left(Region,2),1) <> 贷
group by left(Region,1)
可以，那就用Union
select left(Region,1) as RegionName,
count(distinct Region) as aaa
from moneyinfo
where
Region like %贷%
group by left(Region,1)
Union
select left(Region,1) as RegionName,
count(distinct(Region)) as bbb
from moneyinfo
where
right(left(Region,2),1) <> 贷
group by left(Region,1)
在兩者加一個union all就行
