(Frank Zhou) The following SQL Model Clause pattern can be used to divide consecutive rows into groups based on the smallest running total that are larger than a predetermined value.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help