Hierarchical Data in SQL The Ultimate Guide
INSERT INTO employee id first name role manager id VALUES 15 Alex Salesperson 2 ; The value is then inserted We can run the same SELECT query above to view the data in a hierarchy So inserting a new record is pretty easy We don t need to make any updates to any existing records