Question

Oracle如何对一个多值字段进行分组统计

Answer 1

info表的use字段会有重复的吗比如userA@userA，这样算一个还是2个？
如果没有重复或只算一个的话可以这么统计，不过效率是慢点....
select
userID,(select
count(1)
from
info
where
userID
like
'%'
||
trim(a.userID)
||
'%')
from
user
a;

Answer 2

select
count
*
as
num1
from
info
where
user
like
'%userA%';
select
count
*
as
num2
from
info
where
user
like
'%userB%';
select
count
*
as
num3
from
info
where
user
like
'%userC%';

Answer 3

把你要判断的那个字段
写在group
by
后面