Thank you very much Karen. I appreciate your help and knowledge. Regards John Docherty
On Tuesday, September 20, 2022 at 2:23:53 AM UTC+12 KAREN TELLEF wrote: > Select col1, col2 from table group by col1, col2 having count(*) > 1 > > Karen > > Sent from my iPhone > > On Sep 19, 2022, at 3:50 AM, [email protected] <[email protected]> > wrote: > > Hi, > > > I am not sure if I am missing something that already exists but I was > wondering if there is a quick way of identifying duplicates in a table > using more than one column to do the selection. I was thinking of something > similar to the DELETE DUPLICATES command - but without the DELETE. I just > want to see if any duplicates exist. > > If anyone can tell me if this can be done that would be very much > appreciated. > > Thank you. > > Regards > John Docherty > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/4691e5f2-c2da-4b1e-b00f-f1963382d197n%40googlegroups.com > > <https://groups.google.com/d/msgid/rbase-l/4691e5f2-c2da-4b1e-b00f-f1963382d197n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/25582d24-d6a1-4237-8251-1acb81292078n%40googlegroups.com.
