Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting the latest cumlative gpa
Message
De
13/03/2002 16:18:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Getting the latest cumlative gpa
Divers
Thread ID:
00632402
Message ID:
00632402
Vues:
58
Hello Group,

Every semester the students (suniq) cumulative gpa (cumgpa) is entered into
gpahist table. each cumulative gpa is given a gpauniq number. The largest
gpauniq integer for an associated suniq is the current GPA for that suniq.

How do I change the following SQL to return one row for each suniq and the
latest cumgpa assoiated with it.

SELECT gpauniq, suniq, cumgpa
FROM gpahist

Thanks you

Jim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform