This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
vba:functions:greatest [08.12.2015 08:51:19] yaslaw |
vba:functions:greatest [08.12.2015 09:06:47] yaslaw |
||
---|---|---|---|
Line 16: | Line 16: | ||
===== Beispiele ===== | ===== Beispiele ===== | ||
+ | === VBA === | ||
<code vb>?greatest(4, 5, 13, 7) | <code vb>?greatest(4, 5, 13, 7) | ||
13 | 13 | ||
Line 21: | Line 22: | ||
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 | <code sql>SELECT greatest(maturity_date, key_date, settlement_date) AS max_date | ||
FROM tbl_my_data | FROM tbl_my_data | ||
| max_date | | | max_date | | ||
- | |------------| | ||
| 18.03.2015 | | | 18.03.2015 | | ||
| 30.09.2015 | | | 30.09.2015 | |