客户表:client
cid(客户ID) client_name(客户名) client_man(业务员ID)
1 上海四海厂 3
2 成都美高皮鞋厂 5
...
业务员表:man
Mid man_name
3 小强
5 如花
...
//////////////////////////////////////////////////////////////////
如何统计出业务员所拥有的客户数前10名的数据
cid(客户ID) client_name(客户名) client_man(业务员ID)
1 上海四海厂 3
2 成都美高皮鞋厂 5
...
业务员表:man
Mid man_name
3 小强
5 如花
...
//////////////////////////////////////////////////////////////////
如何统计出业务员所拥有的客户数前10名的数据
from client b
left join man a
on a.mid = b.client_man
order by (select count(cid) from client where client_man=man.Mid) desc
cid(客户ID) client_name(客户名) client_man(业务员ID)
1 上海四海厂 3
2 成都美高皮鞋厂 5
...
业务员表:man
Mid man_name
3 小强
5 如花
...
//////////////////////////////////////////////////////////////////
如何统计出业务员所拥有的客户数前10名的数据 select top 10 b.mid , count(*) cnt
from clinet a , man b where a.client_man = b.mid
group by b.mid
order by cnt desc
from man left join (select client_man, count(cid) from client group by client_man) T on T.client_man=man.Mid
order by 客户数 desc
select top 10 man.*, 客户数=count(cid)
from man left join (select client_man, count(cid) from client group by client_man) T on T.client_man=man.Mid
order by 客户数 desc
from client b
left join man a
on a.mid = b.client_mangroup by a.man_name
SELECT a.Mid, a.man_name, COUNT(*) AS cnt
FROM man AS a, client AS b
WHERE a.mid = b.client_man
GROUP BY a.Mid, a.man_name
ORDER BY cnt DESC
FROM man AS a, client AS b
WHERE a.mid = b.client_man
GROUP BY a.Mid, a.man_name
ORDER BY cnt DESC