Re: Best way to compare records

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 8/21/2024 4:19 PM, a4g atl wrote:
> I will be building the file from the journal receivers. I have my own
> utility to build the fields from the receiver.
>
> I am trying to compare record n-1 with record n.

Will OLAP LAG (or LEAD) help?

-- print the ordinal column number of the prior row, with /this/ row
select
  column_name, table_name, table_schema, ordinal_position, column_heading,
  lag(ordinal_position) over (order by table_schema, table_name, 
column_name) as lag
from syscolumns
where table_schema = 'QGPL'
order by table_schema, table_name, column_name;