Audit table field value change


From the below table example, I'm trying to identify only the records where VAL_IN changed. So I need to see only 4 records in the below example.
I've been reading about LEAD / LAG and think this is probably the function I need to use, but have not had luck with returning results. Can someone please help push me in the right direction.

Subscribe to RSS - MIKEISMAD's blog