Via Lattanzio,23 Milano
+39 02 36592025

Categoria: Firebird SQL

Firebird 3 – How to get record number of dataset

How to get record number of dataset using row_number window function with over().

Example of record number of dataset with even and odd column sorting.

The Haversine formula in Firebird SQL => Calculate distance between two WGS84 Points

Hi, I think might be helpful, today for a customer i do the Haversine formulas for Firebird Sql as a stored procedure. This formula allow you to calculate the distance in meter between two WGS84 datum points(degree points of Earth). You can call the procedure like this:

The result wil be aprox 14Km, the…
Leggi tutto