How to get record number of dataset using row_number window function with over().
SELECT row_number() over(), t.* FROM test t
Example of record number of dataset with even and odd column sorting.
SELECT
row_number() over(),
(CASE WHEN mod(row_number() over(),2) = 0 THEN 'even' ELSE 'odd' END) AS my_column,
custom.* FROM
(
SELECT
t.*
FROM test t ORDER BY t.description
) custom