declare @dw nvarchar(50)
select distinct @dw=department from computers
select @dw as 单位,count(*) as 计算机(台) from computers where department=@dw应该如何写循环呢?谢谢。
select distinct @dw=department from computers
select @dw as 单位,count(*) as 计算机(台) from computers where department=@dw应该如何写循环呢?谢谢。
select distinct @dw=department from computers
select department,count(*) as '计算机(台)' from computers where department in (select distinct department from computers)