Corrigindo: select case when anterior<>mem then data else null end as dia,case when anterior<>mem then mem else null end as memo from ( select row_number() OVER (ORDER BY data ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING ) as linha,first_value(mem) OVER ( ORDER BY data ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING ) as anterior,* from memo order by data ) as janela where anterior<>mem ORDER BY memo;
Bruno E. A. Silva.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
