(Bob Watkins) Oracle’s analytic functions provide a clean way to do gap checking. These functions allow you to see the value in an upcoming row or previous row, while still using the full set-oriented processing of SQL.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help