Statements
AS
DROP
SELECT
Clauses
ORDER BY
JOIN
https://www.db-fiddle.com/f/tPUgzPgpCwo1qKF9HUFn2v/0
CREATE TABLE Persons_dev (
PersonID int,
Name varchar(255)
);
CREATE TABLE Persons_beta (
PersonID int,
Name varchar(255)
);
INSERT INTO Persons_dev (PersonID, Name) VALUES (1,'Ana');
INSERT INTO Persons_dev (PersonID, Name) VALUES (2,'Bojan');
INSERT INTO Persons_dev (PersonID, Name) VALUES (3,'Ceca');
INSERT INTO Persons_dev (PersonID, Name) VALUES (4,'Dejan');
INSERT INTO Persons_dev (PersonID, Name) VALUES (5,'Erik');
INSERT INTO Persons_dev (PersonID, Name) VALUES (6,'Florian');
INSERT INTO Persons_beta (PersonID, Name) VALUES (0,'Zero');
INSERT INTO Persons_beta (PersonID, Name) VALUES (1,'Ana');
INSERT INTO Persons_beta (PersonID, Name) VALUES (2,'Bojan');
INSERT INTO Persons_beta (PersonID, Name) VALUES (3,'Ceca');
INSERT INTO Persons_beta (PersonID, Name) VALUES (4,'Deki');
INSERT INTO Persons_beta (PersonID, Name) VALUES (5,'Erik');
SELECT * FROM Persons_dev
WHERE PersonID NOT IN (SELECT PersonID FROM Persons_beta)
UNION
SELECT * FROM Persons_beta
WHERE PersonID NOT IN (SELECT PersonID FROM Persons_dev)
SELECT Persons_dev.PersonID, Persons_dev.Name, Persons_beta.Name FROM Persons_dev
INNER JOIN Persons_beta ON Persons_dev.PersonID=Persons_beta.PersonID
WHERE Persons_dev.Name != Persons_beta.Name;
https://www.db-fiddle.com/f/tPUgzPgpCwo1qKF9HUFn2v/3
Operators
[NOT] IN
WHERE post_status='publish' AND
No comments:
Post a Comment