[SQL-码农]内查询

今天公司要统计一张有重复用户数据，结果用了内查询

exec PROCEDURE...
GO
CREATE procedure ...
...
AS
Begin

select [key...],count(*) as 'values'
	from (
		select distinct [area...],[Userid...]
			from [Tab..]
			where 1=1
			and ...
	) as a
	where 1=1
	and ...
	group by  [key...]
END