Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY to extract the most oldest record
Message
From
06/01/2003 11:12:05
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
06/01/2003 06:05:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: GROUP BY to extract the most oldest record
Miscellaneous
Thread ID:
00738069
Message ID:
00738382
Views:
17
>Group by pkfield ?
>
>select * from myTable A where datefield = ;
> (select min(datefield) from myTable B where a.pkfield = b.pkfield) ;
> order by pkfield
>
It was with the primary key but you pretty much gave the same answer as the others. Thanks
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform