MariaDB SQL Recursive call to self (single table)

IT, MariaDB, mysql, SQL

If you need to recursively query data based on child / parent relation between rows, you can achieve that using WITH RECURSIVE & UNITE ALL query instructions. Let’s have a look at example “software table”. Software can be declared as virtual machine,...