--openmail-part-0a1399e0-0001
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Try this.
ListValueCount(#List#,"ValueToFind")
This function returns a number of instances for the specifed value in a
list.
Enjoy.
Andrew Kneisler
Cold
I would like to find a way to isolate duplicate values that I get from a
query. Can someone help me? I tried to put all the values into a list,
but I am not sure how to only get the duplicate values.
If you are trying to get a list of column values without duplicates, you
could use:
select
I just recieved the answer to this one and now I cant find the copy that
I've saved...
The gist is that you have to use
SELECT SUM(username) FROM table GROUP BY username
but I too would enjoy seeing the solution again.
-Original Message-
From: Lincoln Manning [EMAIL PROTECTED]
To:
eliminate the duplicates from the SQL side the DISTINCT keyword.
SELECT DISTINCT blah
FROM tableBlah
WHERE columnBlah = moreBlah
-J
-Original Message-
From: Lincoln Manning [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 1:26 PM
To: [EMAIL PROTECTED]
Subject: Duplicate
4 matches
Mail list logo