Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select SQL problem
Message
From
11/04/2022 18:06:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Select SQL problem
Miscellaneous
Thread ID:
01684152
Message ID:
01684152
Views:
59
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é
Next
Reply
Map
View

Click here to load this message in the networking platform