Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT manager_id,emp_id FROM users ,(SELECT @head := 2) head
- WHERE FIND_IN_SET(manager_id, @head) > 0 AND @head := CONCAT(@head, "," , emp_id) ORDER BY manager_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
