Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I tried a simple script to get used to group by function, however, the script didn't run. Here is a screen shot of the script and the error message.
Can anyone tell me what is wrong.
Thank you all !
I did this, but it works if you know a maximum number of products on each purchase
Thank you a lot
you can mark some of my answers as "useful" if you wish
Temp:
Load
Achat,
Produit,
prix,
debut,
fin
from C:\....;
Load
Achat,
Produit,
prix,
debut,
fin
avg(prix) as Avgprix
Resident Temp
Group By Achat,prodit,prix,debut,fin;