Cache SQL and GROUP BY clause
Hi members,
I have these data :
and need to exploit the first character of cot field (Library CDU classification) like this :
I get this result... it's approximatively what I want... but I need it in just one line !
With mySQL I get it with just GROUP BY rcddate
In Cache SQL I have to add {fn LEFT(cot,1)} to get the counts of each first character of cot... and seems {fn WEEK(rcddate)} doesn't make the job !
There is a trick ? or I make something wrong ?
kind regards.
Product version: Caché 2018.1