본문으로 바로가기

중복된 record 찾는 query

category 배우는 것/Database 2015.07.02 15:12

select T2.* from (

select name from dc_baseball_player 

group by concat(name, birth)

having count(*) > 1

) T1 inner join dc_baseball_player T2 on(T1.name = T2.name)


order by T1.name asc

;


댓글을 달아 주세요