SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE empleados ([id] int, [id_manager] int, [nombre] nvarchar(30), [nombre_manager] nvarchar(30)) ; INSERT INTO empleados ([id] , [id_manager], [nombre], [nombre_manager]) VALUES (1, null, 'Fredi', null), (2, 1, 'Mafi', 'Fredi'), (3, 1, 'Diego', 'Fredi'), (4, 2, 'Sofy', 'Mafi'), (5, 4, 'Tomy', 'Sofy') ; /* declare @idColumn int declare @temp int select @idColumn = min( id ) from empleados while @idColumn is not null begin select id_manager select @idColumn = min( id ) from empleados where id > @idColumn end*/ While EXISTS(SELECT * From empleados);