How to compare current record with previous record.

Hi All,

I am inserting data into a temporary table based on while select statement.

I an getting 4 records.

Before inserting into the table i want to compare the current record with previous records(based on only on field data)

if both are same i need to bypass the current record.

if any one have solution please share with me.



And what’s the problem. Save the previous record (or just the one field) to a separate variable and then use the if statement to compare with the current record. Insert the new record only if the condition is met.

Please ask questions about development in the Developer forum. (I’ll move it for you this time.)