DISTINCT" command to find records that do have duplicates. Anyone with
any bright ideas?
John
-----Original Message-----
From: Todd Ashworth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 4:00 PM
To: CF-Talk
Subject: Select IDs that only have 1 entry
I have a table a bit like this:
id whatever1 whatever2
--------------------------------------
10 - blah1 - blah2
12 - abc1 - abc2
10 - xyz1 - xyz2
15 - pdq1 - pdq2
I'm trying to come up with a query that will only pull the rows that
have 1 entry and 1 entry only. None of the ones that have duplicates
should be returned. In this example, 12 and 15 will be returned, but 10
won't. I can think of a few awkward ways to do it, but am looking for a
simple one. I'm not that familiar with MySQL.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
