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. -- 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/F03C3DF3-920D-4CBB-A125-9D0393E5CC93%40cs.com.
