oracle历史sql语句 oraclesql如何查询重复的记录

oraclesql如何查询重复的记录  

select

yljgksmc

,xmbm

,count(1)

from table

group by yljgksmc

,xmbm

having count(1) > 1追问

这个能查询出来相同的记录出现了几次，能列出来相同的记录吗？

select

A.*

from table A

, (

select

yljgksmc

,xmbm

,count(1)

from table

group by yljgksmc

,xmbm

having count(1) > 1 ) B

where a.yljgksmc = b.yljgksmc

and a.xmbm = b.xmbm