SQL: 1999 permit recursive view definition.
Example: Find all employeemanager pairs, where the employee reports to the manager directly or indirectly.
WITH RECURSIVE empl(employee_name, manager_name) AS (
SELECT employee_name, manager_name
FROM manager
UNION
SELECT manager.employee_name, empl.manager_name
FROM manager, empl
WHERE manager.manager_name = empl.employee_name)
SELECT *
FROM empl
This example view, empl, is called the transitive closure of the manager relation.
Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak:
Read More
Follow Us