Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is this possible in an SQL Select Statement?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Is this possible in an SQL Select Statement?
Divers
Thread ID:
00675261
Message ID:
00675261
Vues:
52
Hi
I have a table with the following fields:
Area c(30) Date d and Quantity N(10,2)
I have an sql statement that sums all quantities counts and groups by Area. I would like also, in the same sql statement, to have the Minimum and Maximum dates for every area. I don't know of any way of doing this, other than scan...endscan. Is this possible in a SQL Statement?

Thx
Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform