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
MixT
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers. #5
Display Multiple Rows as a single Line
c12part2
Movies
Hack_this
product_sales
Dynamic Sql command with output variable
Rno 37 boat
mhlongothabani99@gmail.com