Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get the most recent dates
Message
From
07/10/2010 15:21:31
Paul Pravong
Quebec, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Get the most recent dates
Miscellaneous
Thread ID:
01484398
Message ID:
01484398
Views:
98
Hi,

I have mytable that contains 2 fields:

id date
aaa 20101006
aaa 20100906

bbb 20101007
bbb 20100907

to create newtable with 2 records left from 4 above:
aaa 20101006

bbb 20101007

I need to have a sql syntax to do this.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform