How to get duplicate substring and add remaining attach integer value of substring in DB2 sql

Question

My scenario is that i have duplicate substring with string in column like

col1

QWERT

| 16 |

i.e addition of 1+3+12 of duplicate substring(QWERT)and QWERT set as column name

How can I do it using DB2 SQL

Answer 1

Try this:

SELECT SUM(CAST(SUBSTR(t.YourColumn, LOCATE('-',t.YourColumn)+1) as INT)) as sum_total
FROM YourTable t

Sign up