Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find nearest date in select sql
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01186568
Message ID:
01186589
Views:
25
for eg.

ldStart = {^2006-03-01}
ldEnd = {^2006-04-01}

sum(quantity)*sum(price)/sum(quainty) catch for the average price at sales and buyings
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform