vba:functions:greatest
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
vba:functions:greatest [31.08.2015 08:56:05] yaslaw |
vba:functions:greatest [08.12.2015 09:06:47] (current) 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 ===== | ||
| + | === VBA === | ||
| <code vb>?greatest(4, 5, 13, 7) | <code vb>?greatest(4, 5, 13, 7) | ||
| 13 | 13 | ||
| ?greatest("Hans", "Thomas", "Marcel") | ?greatest("Hans", "Thomas", "Marcel") | ||
| Thomas</code> | Thomas</code> | ||
| + | |||
| + | === SQL === | ||
| + | > Vorsicht. Bei grossen Datenmengen könnte die Performance leiden | ||
| + | <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> | ||
vba/functions/greatest.1441004165.txt.gz · Last modified: 31.08.2015 08:56:05 by yaslaw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
