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

Iscriviti alla newsletter

Iscriviti alla nostra newsletter per ricevere offerte di sconto anticipate, aggiornamenti e informazioni sui nuovi prodotti.
Top