SELECT id, str1, SUBSTRING(str1,12,1) concat '-' concat str1 as str2 from t10k UNION ALL SELECT 10000 + id, str1, SUBSTRING(str1,13,1) concat '-' concat str1 as str2 from t10k UNION ALL SELECT 20000 + ...
I started using Db2 in 1991. Five years later, Graeme Birchall released the first version of his "Db2 SQL Cookbook". This book helped me to learn SQL and I used it a lot of times to learn new stuff ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback