Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>Hi friends:
>
>This is what I always wanted to do but I've never got it.
>
>Anyone can tell me what is the correct way for "grouping by" in a SELECT SQL command?
>
>I tried FROM field table, INTO CURSOR field and 1 (result column field) and none of them worked.
>
>This is just one of my tests:
>
> SELECT SUBSTR(f850nfac,2,4) as cpues, f850grav as cgrav, f850ivai as civai, f850exen as cexen, f850tota as ctota, .t. as celijo ;
> FROM &ivaventa WHERE LEFT(DTOS(f850ffac),6)==thisform.peri GROUP BY CPUES NOCONSOLE INTO CURSOR cpuesto
>
What are you trying to do? GROUP BY is designed for aggregating results, that is, for combining data from multiple records into a single record. It's always used in conjunction with the aggregate functions: COUNT(), SUM(), AVG(), MIN() and MAX().
I'm wondering if you really want ORDER BY in your query to organize the results in order by the value of cPues.
Also, while you're there, get rid of the macro operator and use a name expression instead: FROM (ivaventa)
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement