使用groupby clickhouse获取所有列

6mw9ycah 于 2021-07-15 发布在 ClickHouse

关注(0)|答案(1)|浏览(605)

我正在尝试获取clickhouse中所有问题数大于1的学生的专栏。我错过了什么？

SELECT * FROM table_1 PREWHERE IDNUMBER IN (SELECT IDNUMBER, COUNT(QUESTIONS) as XXX FROM table_1 GROUP BY IDNUMBER HAVING XXX > 1)

这是我得到的错误：

DB::Exception: Number of columns in section IN doesn't match. 1 at left, 2 at right.: While executing MergeTreeThread

1条答案

子查询应该只返回一列，而它包含两列：

SELECT * 
FROM table_1 PRE
WHERE IDNUMBER IN (SELECT IDNUMBER FROM table_1 GROUP BY IDNUMBER HAVING COUNT(*) > 1)