Previous in script

[Anonymous]

Hey Guys,

What does  the below script does with previous function?

test:

LOAD * Resident test_temp

where Previous(ID)<>(ID)

order by

, Order_date desc

[MarcoWedel]

It loads each row where ID is different from the previous row when sorted by code and order_date descending.

[balabhaskarqlik]

Data sorted by Code, Order_Date in descending & Comparing the Previous ID value with the Current ID. If the IDs are different it loads, else skip.