g*****u
发帖数: 298 | | c**t
发帖数: 2744 | 2 select t.A, t.B from
(
select A, B, count(B) over (partition by A) as cnt
from YourTable
) t
where t.cnt > 1
3
【在 g*****u 的大作中提到】
: 一个表内容如下，（已经排序）：
: A B
| w******p
发帖数: 166 | 3 select A, B from test.test
where A in
(select A from test.test
group by A
having count(B) > 1
) |
|
