题库 软件开发 题目列表 请写出sql计算每年不同用户发布的笔记数量()
单选题

请写出sql计算每年不同用户发布的笔记数量()

A.

select year,userid,sum(num) as num from  temp2 group by 1,2

B.

select year,userid,count(num) as num from  temp2 group by 1,2

C.

select year,userid,count(num) as num from  temp2

D.

select userid,count(num) as num from  temp2 group by 1

题目信息
校招真题
-
正确率
0
评论
26
点击