Question Tristan Meziere · Nov 25, 2021 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 #SQL #Caché 0 3 0 332