Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Finding Duplicates regardless of case |
Wed, Apr 12 2006 7:35 AM | Permanent Link |
"Bern Rudisill" | I am using the following query to find duplicates
SELECT loginid,COUNT(*) FROM user_security GROUP BY loginid HAVING COUNT(*) > 1 This works great to find duplicates of the same case, but how can I use it to find dups no matter what the case? ex. If I have the following logins in my table the above query will report dups from rec 1 and 5, but I need it to report dups from rec 1,2,3 and 5 1 test 2 Test 3 TeSt 4 test1 5 test Bern -- |
Wed, Apr 12 2006 11:52 AM | Permanent Link |
"John Hay" | Bern
> I am using the following query to find duplicates > > SELECT loginid,COUNT(*) > FROM user_security > GROUP BY loginid > HAVING COUNT(*) > 1 > > This works great to find duplicates of the same case, but how can I use > it to find dups no matter what the case? How about SELECT UPPER(loginid) AS login,COUNT(*) FROM user_security GROUP BY login HAVING COUNT(*) > 1 John |
Wed, Apr 12 2006 12:14 PM | Permanent Link |
"Bern Rudisill" | John Hay wrote:
> SELECT UPPER(loginid) AS login,COUNT(*) > FROM user_security > GROUP BY login > HAVING COUNT(*) > 1 Thanks works like a charm. Never thought about that. Bern -- |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |