SQL Server with 的简单用法:
;with t_cols as (
SELECT user_id,count(*) as acount
FROM users
group by user_id
)select u.*,t.*
FROM Users u
inner JOIN t_cols t
ON t.user_id=u.user_id
;with t_cols as (
SELECT user_id,count(*) as acount
FROM users
group by user_id
)