Hi,
I need to write a query from a simple table ( item, qty, selling date ).
The result should be the sum of qty group by the month of selling date.
Group by seems working only on field names ( i can't do a "group by 1,2,3"
or "group by (extract month from selling date) ) .
Any idea??
Thanks in advance...
Paolo