table(cat,url,user)
aa,sina,a
bb,sohu,b
aa,yahoo,b
aa,google,b怎样才能得到 cat,count(url) ,count(user)aa,3,2
bb,1,1select cat,count(url),count(user) from table group by url,这样count(user)就不对了,高手指教一下
aa,sina,a
bb,sohu,b
aa,yahoo,b
aa,google,b怎样才能得到 cat,count(url) ,count(user)aa,3,2
bb,1,1select cat,count(url),count(user) from table group by url,这样count(user)就不对了,高手指教一下
from table
group by cat;