开发者

group by user that has answered all questions

I have a table of scores per userID. The value of score can be a number or null.

Each user has 20 entries (which defines their 20 questions) and all start off with scores of null.

As they answer each question, the开发者_JAVA技巧 null is replaced by a score.

I would like a query that gets all use ids that have answered all 20 questions, i.e no nulls for that user.

I would really appreciate some help.


Use GROUP BY, HAVING, and COUNT

As this is probably homework I'll try the spoiler markup (mouse over to see the answer!)

select userID from yourtable group by userID having count(score)=20


Try something similar to:

select userID from ... group by userID having count(*)=20
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜