CONDITIONAL_CHANGE_EVENT

This function assigns an event window number to each row, starting from 0, and increments by 1 when the result of evaluating the argument expression on the current row differs from that on the previous row.

Syntax

CONDITIONAL_CHANGE_EVENT ( expression ) OVER ( 

... [ window-partition-clause ] 

... window-order-clause  )

Example

SELECT orderid, 

EMPLOYEEID, 

SHIPNAME, 

CONDITIONAL_CHANGE_EVENT(EMPLOYEEID)    

   OVER (ORDER BY EMPLOYEEID)

   FROM /shared/examples/ds_orders/tutorial/orders

Remarks

CONDITIONAL_CHANGE_EVENT must contain an ORDER BY clause within its analytic clause