select 业务员,客户数=count(客户名称) from company group by 业务员
select 业务员,count(客户名称) 客户数 from company group by 业务员
select 业务员,count(1) as 客户数 from company group by 业务员
if object_id('company') is not null drop table company go create table company ( 客户名称 varchar(10), 业务员 varchar(10) ) go insert into company select '王三','张三' union all select '王四','张三' union all select '王五','张四' union all select '王六','张四' go select 业务员,客户数量=count(*) from company group by 业务员 go /* 业务员 客户数量 ---------- ----------- 张三 2 张四 2(2 行受影响) */
在asp中我应该如何输出呢? <% set rsxc=server.createobject("adodb.recordset") rsxc.open "select count(*) from company group by gendanren",conn,1,1 %>
if object_id('company') is not null
drop table company
go
create table company
(
客户名称 varchar(10),
业务员 varchar(10)
)
go
insert into company
select '王三','张三' union all
select '王四','张三' union all
select '王五','张四' union all
select '王六','张四'
go
select 业务员,客户数量=count(*) from company group by 业务员
go
/*
业务员 客户数量
---------- -----------
张三 2
张四 2(2 行受影响)
*/
<%
set rsxc=server.createobject("adodb.recordset")
rsxc.open "select count(*) from company group by gendanren",conn,1,1
%>