Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get max() record?
Message
From
16/01/2004 06:40:37
 
 
To
16/01/2004 06:24:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00867397
Message ID:
00867406
Views:
16
For multiple equal:
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 SalesNo, SalesDate, Amount AS MaxAmount ;
FROM Sales S WHERE Amount >= ALL (SELECT Amount FROM Sales WHERE SalesDate=S.SalesDate) ;
INTO CURSOR MaxForDay1

or

SELECT SalesNo, SalesDate, Amount AS MaxAmount ;
FROM Sales S WHERE Amount=(SELECT MAX(Amount) FROM Sales X WHERE X.SalesDate=S.SalesDate) ;
INTO CURSOR MaxForDay2
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform