Filtri Menu 0 0.00

Firebird 3 – How to get record number of dataset

Firebird 3 – How to get record number of dataset

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
Share:

Subscribe to newsletter

Subscribe to our newsletter to receive early discount offers, updates and new products info.
Top