Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
The relational division
CREATE TABLE a (id INT, b_id INT); CREATE TABLE b (id INT); INSERT INTO a VALUES (1, 1), (1, 2), (1, 3), (2, 2), (3, 2), (3, 3); DECLARE @i INT = 0; WHILE @i < 5 BEGIN TRUNCATE TABLE b; IF @i = 0 INSERT b VALUES (1), (2), (3); IF @i = 1 INSERT b VALUES (1), (2); IF @i = 2 INSERT b VALUES (2); IF @i = 3 INSERT b VALUES (2), (3); SELECT DISTINCT x.id FROM a AS x WHERE NOT EXISTS ( SELECT * FROM b AS y WHERE NOT EXISTS ( SELECT * FROM a AS z WHERE z.id = x.id AND z.b_id=y.id ) ) SET @i = @i + 1; END;
run
|
edit
|
history
|
help
0
aa
bvbn
Jogarao1
Greatest_N_Per_Group
tr3
Rank group by
Select empID whose salary is greater than their managers
TUAN 7_QUAN LY DE TAI
Creation tables
Manish SQL