Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH CTE_podwladni(nazwisko, id, poziom)
- AS
- (
- SELECT nazwisko,
- id,
- 0
- FROM Pracownicy
- WHERE nazwisko = 'Mielcarz'
- UNION ALL
- SELECT P.Nazwisko,
- P.id,
- T.poziom + 1
- FROM
- Pracownicy P
- JOIN CTE_podwladni T
- ON P.szef = T.id
- )
- Select * from CTE_podwladni
- SELECT * FROM Pracownicy
- ORDER BY stanowisko;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement