SQLite 3.16

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
(1,1,1,1),
(2,2,2,2),(2,2,2,2),
(3,3,3,3),
(4,4,4,4);
insert into TableB values
(1,1,1,1),
(2,2,2,2),
(3,3,3,3),(3,3,3,3),(3,3,3,3),
(5,5,5,5);
SELECT col1, col2, col3, col4
FROM
(
  SELECT a.col1, a.col2, a.col3, a.col4,
  (select count(*) from TableA a2
   where a2.col1 = a.col1 
     and a2.col2 = a.col2 
     and a2.col3 = a.col3 
     and a2.col4 = a.col4
     and a2.rowid >= a.rowid) as rn
  FROM TableA a
  EXCEPT
  SELECT b.col1, b.col2, b.col3, b.col4,
  (select count(*) from TableB b2
   where b2.col1 = b.col1 
     and b2.col2 = b.col2 
     and b2.col3 = b.col3 
     and b2.col4 = b.col4
     and b2.rowid >= b.rowid)
  FROM TableB b
  UNION ALL
  SELECT col1, col2, col3, col4, 0
  FROM TableB
) q
ORDER BY col1, col2, col3, col4


col1
col2
col3
col4


1
1
1
1

2
2
2
2

2
2
2
2

3
3
3
3

3
3
3
3

3
3
3
3

4
4
4
4

5
5
5
5