How to compare current row values with next row values in BigQuery Stored Procedure

[vgandikota]

Hi,

In Big Query stored procedure, I need to compare the current row values with next row values. How can I achieve this.

In MySQL, we can get the next row values using select * from limit currentrownumber+1, 1 and compare the values.