SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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 @counter SET @counter = 0 WHILE (@counter < 4) BEGIN SELECT id_manager FROM empleados WHERE id_maanger >= @counter @counter = @counter + 1 END
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear