I used count(*) > 1
but it is showing duplicate rows as well. I want to see only unique rows
Table: A
id name class key
1 abc 1 ACB3
1 abc 1 ACB3
2 ccd 2 XY4
2 ccd 2 ZZ5
Result expected:
id name class key
1 abc 1 ACB3
2 ccd 2 XY4
2 ccd 2 ZZ5
Query:
select id, name, class, count(*)
from A
group by id, name, class
having count(*) > 1
and result I got
id name class
1 abc 1
1 abc 1
2 ccd 2
2 ccd 2
You need to sign in to view this answers
Leave feedback about this