Is it possible to SUM only first two characters using
GROUP BY in MySQL?
Such as :
SELECT SUM(Substr(period, 1,2) FROM table GROUP BY period
I have tried these SQL. But didn't effect because of using
GROUP BY. The result of these query is sum all of the period value.