This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
vba:functions:greatest [31.08.2015 08:56:05] yaslaw |
vba:functions:greatest [08.12.2015 08:51:33] yaslaw |
||
---|---|---|---|
Line 13: | Line 13: | ||
{{%%fname%%|Download %%fname%% (V-%%version%%)}} | {{%%fname%%|Download %%fname%% (V-%%version%%)}} | ||
- | Siehe auch [[vba:functions:least]] | + | >Siehe auch [[vba:functions:least]] |
===== Beispiele ===== | ===== Beispiele ===== | ||
Line 20: | Line 20: | ||
?greatest("Hans", "Thomas", "Marcel") | ?greatest("Hans", "Thomas", "Marcel") | ||
Thomas</code> | Thomas</code> | ||
+ | |||
+ | <code sql>SELECT greatest(maturity_date, key_date, settlement_date) AS max_date | ||
+ | FROM tbl_my_data | ||
+ | |||
+ | | max_date | | ||
+ | | 18.03.2015 | | ||
+ | | 30.09.2015 | | ||
+ | | 30.09.2015 | | ||
+ | | 30.09.2015 | | ||
+ | | 18.03.2015 | | ||
+ | </code> | ||
===== Code ===== | ===== Code ===== | ||
<source '%%fpath%%/%%fname%%' vb> | <source '%%fpath%%/%%fname%%' vb> |