Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
テスト2
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE Tbl_A (keycol CHAR(1) PRIMARY KEY, col_1 INTEGER , col_2 INTEGER, col_3 INTEGER); CREATE TABLE Tbl_B (keycol CHAR(1) PRIMARY KEY, col_1 INTEGER, col_2 INTEGER, col_3 INTEGER); /* 等しいテーブル同士のケース */ DELETE FROM Tbl_A; INSERT INTO Tbl_A VALUES('A', 2, 3, 4); INSERT INTO Tbl_A VALUES('B', 0, 7, 9); INSERT INTO Tbl_A VALUES('C', 5, 1, 6); DELETE FROM Tbl_B; INSERT INTO Tbl_B VALUES('A', 2, 3, 4); INSERT INTO Tbl_B VALUES('B', 0, 7, 9); INSERT INTO Tbl_B VALUES('C', 5, 1, 6); select case when count(*)=0 then 'ok' else 'ng' end as merged from (( select * from Tbl_A union select * from Tbl_B) except (select * from Tbl_A intersect select * from Tbl_B )) as tmp
run
|
edit
|
history
|
help
0
TestTaskSolutionByTania
Primeiro
search all tables for string
string concatenation as aggregate operator in group by
Test row_number() ordering when CTE referenced multiple times
Change
Merge statement
SQL for beginners( defined with errors while enforcing constraints)
Common Table Expression
mysqltest