By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
Name VARCHAR(1) NOT NULL PRIMARY KEY
,age INTEGER NOT NULL
,phoneNumber INTEGER NOT NULL
);
INSERT INTO mytable(Name,age,phoneNumber) VALUES ('A',26,12345);
INSERT INTO mytable(Name,age,phoneNumber) VALUES ('B',34,87654);
INSERT INTO mytable(Name,age,phoneNumber) VALUES ('C',5,98765);
3 rows affected
with cte as (
select name, age, age % 10 new_age, phoneNumber, 1 i from mytable
union all
select name, age, 10, phoneNumber, i + 1
from cte
where age > i * 10
)
select name, new_age age, phoneNumber from cte order by name, age desc
| name | age | phoneNumber |
|---|---|---|
| A | 10 | 12345 |
| A | 10 | 12345 |
| A | 6 | 12345 |
| B | 10 | 87654 |
| B | 10 | 87654 |
| B | 10 | 87654 |
| B | 4 | 87654 |
| C | 5 | 98765 |