3 ms·
Select Prefix, count(1) as n From (select LEFT(Foo,4) as Prefix, * from mytable) GROUP BY Prefix ORDER BY Prefix
by projektfu 7y ago
Select Prefix, count(1) as n
From (select LEFT(Foo,4) as Prefix, *
from mytable)
GROUP BY Prefix
ORDER BY Prefix