Postgres 11

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

create table lagger(
textColA text,
textColB text,
textColC text,
textColD text,
textColE text,
numCol1 numeric,
numCol2 numeric,
eventNum integer);

CREATE TABLE


insert into lagger values
('x','y','z','foo','bar',1,2,1),
('x','y','z','foo','bar',1,2,2),
('x','y','z','foo','bar',1.1,2,3),
('x','y','z','foo','bar',1.1,2,4),
('x','y','z','foo','bar',1,2,5),
('x','y','z','foo','bar',1,2,6);

INSERT 0 6


select * from lagger;


textcola
textcolb
textcolc
textcold
textcole
numcol1
numcol2
eventnum


x
y
z
foo
bar
1
2
1

x
y
z
foo
bar
1
2
2

x
y
z
foo
bar
1.1
2
3

x
y
z
foo
bar
1.1
2
4

x
y
z
foo
bar
1
2
5

x
y
z
foo
bar
1
2
6



SELECT 6


select textColA, textColB, textColC, textColD, textColE, numCol1, numCol2, eventNum
from (
  select
    l.*,
    lag(textColA) over w as lagTextColA,
    lag(textColB) over w as lagTextColB,
    lag(textColC) over w as lagTextColC,
    lag(textColD) over w as lagTextColD,
    lag(textColE) over w as lagTextColE,
    lag(numCol1) over w as lagNumCol1,
    lag(numCol2) over w as lagNumCol2
  from lagger l
  window w as (order by eventNum)
) x
where
   textColA is distinct from lagTextColA
or textColB is distinct from lagTextColB
or textColC is distinct from lagTextColC
or textColD is distinct from lagTextColD
or textColE is distinct from lagTextColE
or numCol1 is distinct from lagNumCol1
or numCol2 is distinct from lagNumCol2
;


textcola
textcolb
textcolc
textcold
textcole
numcol1
numcol2
eventnum


x
y
z
foo
bar
1
2
1

x
y
z
foo
bar
1.1
2
3

x
y
z
foo
bar
1
2
5



SELECT 3

textcola	textcolb	textcolc	textcold	textcole	numcol1	numcol2	eventnum
x	y	z	foo	bar	1	2	1
x	y	z	foo	bar	1	2	2
x	y	z	foo	bar	1.1	2	3
x	y	z	foo	bar	1.1	2	4
x	y	z	foo	bar	1	2	5
x	y	z	foo	bar	1	2	6

textcola	textcolb	textcolc	textcold	textcole	numcol1	numcol2	eventnum
x	y	z	foo	bar	1	2	1
x	y	z	foo	bar	1	2	2
x	y	z	foo	bar	1.1	2	3
x	y	z	foo	bar	1.1	2	4
x	y	z	foo	bar	1	2	5
x	y	z	foo	bar	1	2	6

textcola	textcolb	textcolc	textcold	textcole	numcol1	numcol2	eventnum
x	y	z	foo	bar	1	2	1
x	y	z	foo	bar	1	2	2
x	y	z	foo	bar	1.1	2	3
x	y	z	foo	bar	1.1	2	4
x	y	z	foo	bar	1	2	5
x	y	z	foo	bar	1	2	6