This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
vba:access:functions:rownr [04.07.2018 09:20:59] yaslaw |
vba:access:functions:rownr [04.07.2018 09:23:00] (current) yaslaw [Beispiele] |
||
---|---|---|---|
Line 12: | Line 12: | ||
==Version %%version%% (%%vdate%%)== | ==Version %%version%% (%%vdate%%)== | ||
+ | ===== Beispiele ===== | ||
+ | <code sql>SELECT | ||
+ | rownr(123, t.id) , | ||
+ | t.* | ||
+ | FROM tbl_data t | ||
+ | ORDER BY t.sort</code> | ||
===== Code ===== | ===== Code ===== | ||
<source '%%fpath%%/%%fname%%' vb> | <source '%%fpath%%/%%fname%%' vb> |