Other. Returns the sequence number of a given row in the window.
getrowid ( row )
| row | A row in a window. |
Returns the sequence number of a given row in the window. The function takes a window ID as its argument, and returns the sequence number of the row in the window. This sequence number is known as the rowid, assigned uniquely as the rows get inserted. The getrowid function returns a 64-bit integer as its datatype return form. It always returns the row identifier of the record passed in as a parameter to the function. It can be used with a stream, delta stream, or a window.
CREATE MEMORY STORE "memstore"; CREATE INPUT WINDOW iwin1 SCHEMA (a money(1), b money(3)) PRIMARY KEY (a) MEMORY STORE "memstore"; CREATE INPUT WINDOW iwin2 SCHEMA (a money(1), b money(3)) PRIMARY KEY (a) MEMORY STORE "memstore";