Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using the MAX function
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01509686
Message ID:
01509687
Vues:
52
>I am wondering how I can get the record for a certain MemberID; there are several records of termination for this one person, and they are valid because the person had insurance coverage at various points in time and eventually allowed his coverage to Terminate for one reason or another. I have to fin the record having the MAXIMUM Termination_Date.
>
>I tried using the MAX(Term_Date) function in the HAVING clause but it doesn't have enough arguments, and doesn't seem to apply there.
>
>It seems that MAX in FoxPro and T-SQL are a bit different.


how about something like:
select top 1 coverages.pk,coverages.member_id from coverages order by member_id asc, expdate desc
Brandon Harker
Sebae Data Solutions
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform