'DB2 SQL : selecting rows where value is different from previous one

Let's say I have a table (PERSON) like this : Table Person

I would like to select only the rows where the value of column "C" has changed from previous row. In this case, I should get : rows 1, 4, 5, 7, 8, 9 and 15. I can't figure out how to achieve this. Does someone has an idea please ?

Thank you

sqldb2


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions