Re: [firebird-support] Find duplicate multi-row entries

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
group by + havingis your friend.E.g.Select field1, field2, count(*)From 
tablexGroup by field1, field2Having count(*)>1
But in your scenario i do not know if this is the solution. Question is if 
record was changed and in next update "restored" and once again changed is this 
duplicate or no?If yes above query is ok if no then procedure is your friend.
And for the future change your audit trigger and check before if there was any 
change
Regards,Karol Bieniaszewski
null