Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get max() record?
Message
De
17/01/2004 05:29:11
 
 
À
16/01/2004 22:01:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00867397
Message ID:
00867766
Vues:
23
John,

you need a criteria for get a row for equal SalesDate ,MaxAmount .
On next example i use MAX(SalesNo), but others are possible;
also RECNO() is possible, but it is probably an ugly one chosen
if reported to database tables.
CREATE CURSOR Sales ( SalesNo c(6), SalesDate D,Amount Y)
INSERT INTO sales VALUES ('A00001',{^2003/01/01},$100)
INSERT INTO sales VALUES ('A00002',{^2003/01/01},$200)
INSERT INTO sales VALUES ('A00003',{^2003/01/02},$100)
INSERT INTO sales VALUES ('A00004',{^2003/01/01},$200)

SELECT MAX(SalesNo), SalesDate, Amount AS MaxAmount ;
FROM Sales S WHERE Amount >= ALL (SELECT Amount FROM Sales WHERE SalesDate=S.SalesDate) ;
GROUP BY 2,3;
INTO CURSOR MaxForDay1

SELECT MAX(SalesNo), SalesDate, Amount AS MaxAmount ;
FROM Sales S WHERE Amount=(SELECT MAX(Amount) FROM Sales X WHERE X.SalesDate=S.SalesDate) ;
GROUP BY 2,3;
INTO CURSOR MaxForDay2
Fabio
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform