[SQL-码农]内查询

来源:互联网 发布:醉八仙宠物技能数据库 编辑:程序博客网 时间:2024/06/01 07:30

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

exec PROCEDURE...GOCREATE procedure ......ASBeginselect [key...],count(*) as 'values'from (select distinct [area...],[Userid...]from [Tab..]where 1=1and ...) as awhere 1=1and ...group by  [key...]END



原创粉丝点击