How to get record number of dataset using row_number window function with over().
1 2 3 4 |
SELECT row_number() over(), t.* FROM test t |
Example of record number of dataset with even and odd column sorting.
1 2 3 4 5 6 7 8 9 |
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 |
Firebird 3 a differenza di Firebird 2.5 non necessita di una libreria diversa di connessione al DB. In Windows, fino ad oggi per distribuire embedded Firebird si usava fbembedd.dll al posto di fbclient.dll, ora con Firebird 3.0 si utilizza sempre fbclient.dll sia per la connessione ad un server Firebird sia per la gestione dei DB…
Leggi tutto
SmartFB is our internal tool to manage Firebird & Interbase databases, so we use smartFB instead IBExpert. SmartFB is a simple VCL program that we use to have an access to our databases in every PC and Virtual Machines where we not need a simple access to our databases. So we integrate in smartFB some…
Leggi tutto
Charset encoding in Firebird 3.0, come è noto in un campo di una tabella di tipo varchar o char è possibile definire il tipo di encoding gestito, oppure non specificarlo. Tramite Firebird è possibile convertire il contenuto di tale campo da un charset ad un’altro semplicemente con l’istruzione SQL “cast”. Facciamo un esempio, nella mia…
Leggi tutto
Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Leggi tutto
SmartFB is a free SQL client for Interbase and Firebird made for internal / educational use. As we think it will be useful we decided to make it available for download. It is in “beta” version, but I think it could be useful, so you can download it from the following links: – Download Windows…
Leggi tutto