Can anyone help me to show the second table from the first table in Mysql. I cannot understand how to approach the problem. I know the concept of left join and order by, but still cannot figure it out.
BTREE
Input Table:
Desired Output:
Asked
Active
Viewed 44 times
0
-
Please tell the MySQL version you are using. – Nishant Gupta Jun 03 '22 at 08:04
-
You must provide precise MySQL version info and input data as textual code-formatted CREATE TABLE + INSERT INTO. – Akina Jun 03 '22 at 08:04
-
Possible duplicate: https://stackoverflow.com/q/20215744/861716 – Gert Arnold Jun 03 '22 at 08:12
-
The version is MySQL 8+. – Reeju Ballabh Jun 03 '22 at 08:27
1 Answers
0
Use recursive CTE:
with recursive managers as (
select EmployeeId, name as 'Employee', 'Super Boss' as 'Manager', 1 as Level, ManagerId
from employees
where ManagerId is null
union
select e.EmployeeId, e.name, m.Employee, Level+1, e.ManagerId
from employees e
join managers m on m.EmployeeId=e.ManagerId
)
select Employee, Manager, Level
from managers
slaakso
- 7,222
- 2
- 14
- 27
-
I don't know how recursive CTE works in Mysql but I will look into it and try to understand it. Thank you so much for the answer anyway. – Reeju Ballabh Jun 03 '22 at 13:24