https://stackoverflow.com/questions/710212/is-there-a-way-to-access-the-previous-row-value-in-a-select-statement
Anonymous
Design for the future, because it will be here sooner than you think.