Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select SQL problem
Message
De
11/04/2022 18:06:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Select SQL problem
Divers
Thread ID:
01684152
Message ID:
01684152
Vues:
60
Hello all,

I'd like for the following code to work. The where is the important part that doesn't want to cooperate ;-)

SELECT Field1, COUNT(IdCase) as TotCases;
FROM Table1 ;
group by Field1;
where TotCases > 3

So to only get the rows where TotCases is greater thant 3 how should I code my where?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform