SQLite Forum

Novice question concerning adding conditional incremental integer counter
Thank you.  At first, I didn't understand this but see that, if rows change strongs_no values from not 'punc2' to 'punc2', they would not get set to null on a new update run without this union code.  That is something I would have definitely missed, especially since have never used a window function before.