The Indispensable Karen T. !
b
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com
------ Original Message ------
From "'KAREN TELLEF' via RBASE-L" <rbase-l@googlegroups.com>
To rbase-l@googlegroups.com
Date 9/19/2022 7:23:45 AM
Subject Re: [RBASE-L] - Finding Duplicates
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, johnd...@gmail.com <johndoc...@gmail.com>
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/F03C3DF3-920D-4CBB-A125-9D0393E5CC93%40cs.com
<https://groups.google.com/d/msgid/rbase-l/F03C3DF3-920D-4CBB-A125-9D0393E5CC93%40cs.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emfe2ef0fc-ab65-4c99-9bcf-546d605d04d3%407a56210a.com.