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') ; SELECT FROM empleados HAVING COUNT(id_manager) > 1
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear