I am looking for a query(functions) for example to be implemented on a table
where a column has a few numeric values with perhaps even some rows vacant.
In the final result row I want the last numeric value of the column to be
printed.

For example to illustrate:

A B C D
1 1.2 2.1
2 3.5 9.3 2.3
3 4.9 5.5 4.6
4 2.3
5 4.1
..
..
8 2.3 4.9 5.5 4.1

Here the result row is number(8) where the results from the above columns
are printed. The results only follow one rule that is the last numeric value
is printed irrespective of whether if its smallest or largest value in that
column.