Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COUNTing my SELECTion
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
COUNTing my SELECTion
Divers
Thread ID:
00850715
Message ID:
00850715
Vues:
65
Hello Foxperts,

Working in FPD/2.5 (!), I've got most of what I need from this statement:
SELECT t_date, user, COUNT(pay_track), SUM(payment)  FROM u_hpay ; 
	GROUP BY t_date, user  INTO ARRAY uhp_tmp
The COUNT() is the focus of this question:
I'm getting the number of pay_track entries (as expected).
How can I get the number of unique pay_track entries?
TIA,
Randy Bosma
VFP - Because life is too short to code in something else...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform