SQLite 3.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table TableA (col1 int, col2 int, col3 int, col4 int);
create table TableB (col1 int, col2 int, col3 int, col4 int);
insert into TableA values
(2,4,1,3),(2,4,1,3),
(2,2,2,1),
(4,5,2,4),
(1,4,2,5);
insert into TableB values
(2,2,2,1),
(2,4,1,3),(2,4,1,3),(2,4,1,3),
(5,3,2,3);
SELECT col1, col2, col3, col4
FROM TableA
EXCEPT
SELECT col1, col2, col3, col4
FROM TableB
UNION ALL
SELECT col1, col2, col3, col4
FROM TableB


col1
col2
col3
col4


1
4
2
5

4
5
2
4

2
2
2
1

2
4
1
3

2
4
1
3

2
4
1
3

5
3
2
3