给定表R1，结果是什么？

Question

A   B   C
3   1   0
5   2   3
5   4   2
2   6   3

给定表R1，结果是什么？

Select R1.A , count(*) 
from R1 (select A from R1 GROUP BY A ) R2
where R1.A >= R2.A 
group by R1.A 
HAVING COUNT (*) > 1; 

Answer 1

我猜您的查询在first R1之后缺少逗号。如果您添加了这一点，结果可能如下所示-

Select R1.A , count(*) 
from R1, (select A from R1 GROUP BY A ) R2
where R1.A >= R2.A 
group by R1.A 
HAVING COUNT (*) > 1; 

结果-

A  |  count(*)
--------------
3  |  2
5  |  6