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
mysql4
Adding, subtracting, rounding and calculating differences
Life cycle
TSQL - Unique string generator
bc150200055
20181cse0012dbmsca2
Pivot and Unpivot
#Temp Table fill
SQL_Joins_RankingFunctions
robot-grading