Hi,
SELECT DISTINCT fruit, count(fruit) AS fruitcount
FROM greengrocer
GROUP BY fruit
ORDER BY fruit
HTH,
Chris
--Original Message--
From: "chad jackson" [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: January 25, 2001 11:39:49 PM GMT
Subject: help with sql query/CF
Hi,
I
Try:
SELECT fruit, COUNT(fruit) AS NumFruits
FROM greengrocer
GROUP BY fruit
ORDER BY fruit
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the
Select fruit,count(fruit)
From greengrocer
Group By fruit
John Anderson
http://www.aloha-webdesign.com
-Original Message-
From: chad jackson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 3:40 PM
To: CF-Talk
Subject: help with sql query/CF
Hi,
I have a standard query
3 matches
Mail list logo