oracle中count()如何统计多列？

[灵魂的追宿]

我要统计name1列和name2列，sql语句怎么写？

[gelyon]

select count(name1),count(name2) from your_table;
通过这样计算，不会计算你字段为null的

[灵魂的追宿]

[Quote=引用 1 楼 gelyon 的回复:]
select count(name1),count(name2) from your_table;
通过这样计算，不会计算你字段为null的
[/Quote]

我想要这样的select name1,count(name1),name2,count(name2) from test.....

[gelyon]

select name1,total1,name2,total2 from
(
select name1,count(name1) total1 from test group by name1
)
,
(select name2,count(name2) total2 from test group by name2
);

[灵魂的追宿]

[Quote=引用 3 楼 gelyon 的回复:]
select name1,total1,name2,total2 from
(
select name1,count(name1) total1 from test group by name1
)
,
(select name2,count(name2) total2 from test group by name2
);
[/Quote]

这样写能统计出来，但是有很多重复的记录

[gelyon]

[Quote=引用 4 楼 chengyou1985 的回复:]
引用 3 楼 gelyon 的回复:
select name1,total1,name2,total2 from
(
select name1,count(name1) total1 from test group by name1
)
,
(select name2,count(name2) total2 from test group by name2
);


这样写能统……
[/Quote]

select name1,total1,name2,total2 from
(
select name1,count( distinct name1) total1 from test group by name1
)
,
(select name2,count( distinct name2) total2 from test group by name2
);

[灵魂的追宿]

[Quote=引用 5 楼 gelyon 的回复:]
引用 4 楼 chengyou1985 的回复:
引用 3 楼 gelyon 的回复:
select name1,total1,name2,total2 from
(
select name1,count(name1) total1 from test group by name1
)
,
(select name2,count(name2) total2 from test gro……
[/Quote]

这样不行，没有统计出来，而且也有很多重复数据

[灵魂的追宿]

加了distinct无法统计

[beita258]

select name1,count(name1)over(partition by name1 ),name2,count(name2)over(partition by name2) from test.....

[灵魂的追宿]

[Quote=引用 8 楼 beita258 的回复:]
select name1,count(name1)over(partition by name1 ),name2,count(name2)over(partition by name2) from test.....
[/Quote]

这个方法可以，嘿嘿~！