General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only