开发者

T-SQL query and group by reporting help

So I have some data that looks like this.

`USERID1 USERID2`
    1        10
 开发者_如何学Python   2        20
    2        30
    3        40
    3        50
    1        10
    2        20
    2        30
    3        50

I want a query that produces the following

`USERID1     COUNT`
    2        2
    3        2

It's a group by query that shows me the count of unique USERID2 for each USERID1 that has more than 1 USERID2 associated with it. God I hope you aren't as confused as I am by that last statement.


Does this work?

SELECT USERID1, COUNT(DISTINCT USERID2) 
  FROM [table] 
 GROUP BY USERID1 
HAVING COUNT(DISTINCT USERID2) > 1


How about:

select userid1, count(*) from tablename group by userid1 having count(*) > 1


Could you try something like this:-

SELECT UserID1, COUNT(UserID2) FROM Table1 GROUP BY UserId1
HAVING COUNT(UserID2)>1


How about this??

select userid1, count(distinct userid2) from nameOfTable where userid1 > 1 group by userid1


select userid1, count(userID1) as [count] from tablename group by userid1 order by userid1
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜