Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
STD() in SQL SELECT/Views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00024836
Message ID:
00024864
Vues:
35
>>Does anyone know how an EASY way (or any way) to use the STD() function (which works with the CALCULATE command) in a view or a SQL SELECT? Is my only option to calculate the STD() for each group with a separate CALCULATE command?
>
>I guess so. :-(

That's a tough one for SQL because STD needs a mean, total number of values, and each individual value to do the calculation. So it would have to go through to get the mean first, then go back to do the actual STD, not something that one SQL loop could do...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform