I have a table “Processor types” with column name processor.
SELECT processor, SUM(processor) AS Total from processor-types where (processor like ‘%i210%’)
and ddate like ‘20161009’ group by processor
i210 2016 8
ethernet i210-t1 5
intelâ® ethernet controller i210-at 5
But I need output in the summarized form of the total and generic name in processor column as i210.
Eg: (ethernet i210-t1) string to replaced by i210
will you all please suggest me how to do. If so send me sample query.