Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Min and Max values
Message
De
10/09/2000 15:45:34
Ian Johnston
Computer Software Solutions
Woodland, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Min and Max values
Divers
Thread ID:
00414721
Message ID:
00414721
Vues:
57
I am doing a select against a table with a group by clause, I wish to have the cursor contain the min and max values for the group, I am not getting the correct values. the select is as follows :
sele district,route,min(odometer) as begin_point, .f. as found_beg, max(odometer) as end_point, .f. as found_end ;
from pcs!pcs_locations group by district,route into cursor log_data

TIA
Ian
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform