SQL++ - Window Functions(2)

Another example of Window functions

ROW_NUMBER() It returns a unique row number for every object in every window partition. In each window partition, the row numbering starts at 1.

The window order clause determines the sort order of the objects. If the window order clause is omitted, the return values may be unpredictable.

To run this example, click the button in the top right corner of the code editor.

Code Editor