oracle单表查询需要用对一列拆分，如何处理呀。

[alexzhu1973]

Table1
Id name status type
1 a start 1
2 b end 2
3 a start 1
4 b end 2
5 a start 1
6 b end 2
7 a start 1
8 b end 2


期望结果：

Status＝‘start’并且count（type＝1）count(type＝2)
Group by name
得到列为：
Name 时长 type1次数合计 type2次数合计

我用
Select t.name,count(status) s1,sum(type=1) t1,sum(type=2) t2
From table1 t
where status=’start’
group by name
不正确

请问这个语句怎么写呀？

[ahua3515]

select t.name,status,sum(decode(type,1,1,2,0),sum(decode(type,2,1,1,0)) from talbe1 t where status='start' group by name,status

[hebo2005]

Select t.name,count(status) s1,sum(decode(type,1,1,0)) t1,sum(decode(type,2,1,0)) t2
From table1 t
where status=’start’
group by name

[alexzhu1973]

我实际表格group by的列有3列
用楼上的方法试过，有许多重复列怎么去除呀

[panxuan]

使用distinct

[panxuan]

Select  distinct  t.name,count(status) s1,sum(decode(type,1,1,0)) t1,sum(decode(type,2,1,0)) t2  From table1 t  where status=’start’  group by name

[knowledge_Is_Life]

这个简单啊,网上搜一下就得到答案了.

[UltraBejing]

有点难度哦