Rizvi's Blog
Pages
Home
Spring
Spring Boot
AWS
Gradle
Maven
Hibernate
Git
Logger
Design Pattern
Web Services
Linux
GraphQL
Contact
Monday, August 29, 2016
PostgreSQL find duplicate records
select TCODE, external_id, count(*)
from TM_EXTERNAL_ACCOUNT
group by TCODE, external_id
HAVING count(*) > 1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment