Hi, a simple group by question.
How to I get a table to group by month when having a dato field...
SELECT COUNT(*), month(dato) AS MND
FROM SALG
GROUP BY month(dato)
will not work because I'm not allowed to use expressions in group by...
Other SQL can, not Valentina... why or what is the workaraound...
Please help...
I also need to get week number of year grouping as well.