Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
V6s5, View Avg() the top nos. = first no. of same lineitems
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
V6s5, View Avg() the top nos. = first no. of same lineitems
Divers
Thread ID:
00805192
Message ID:
00805192
Vues:
48
Hi all

I have this typical requirement where I have to AVG() the Top line items which equal to the First Line item of the same set. to explain...
iID  ParentID  Col 10  Col 13
1    22        39.5    5.936
2    22        39.5    6.002
3    22        39.5    6.027
4    22        43.5    6.078
5    22        39.5    6.106
Of the above I have to avg() col 13 based on the first reading of col 10 upto the readings of col 10 which are constant, but nothing after the breakage. ie. I have to avg(5.936, 6.002, 6.027) but not to avg 6.106 though col 10 equals to the first value. This is a child of the parent-child so I also have to take care of subset to ParentID 22 only as in this case.

I hope I have been able to explain this.

Please advise.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform