# RANK variable in DB

**URL:** <https://forum.knime.com/t/rank-variable-in-db/30564>\
**Category:** KNIME Analytics Platform\
**Created:** [February 9, 2021, 11:33am UTC](https://forum.knime.com/t/rank-variable-in-db/30564 "2021-02-09T11:33:49Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [March 30, 2021, 7:02pm UTC](https://forum.knime.com/t/rank-variable-in-db/30564/9 "2021-03-30T19:02:30Z")

</div>

@chanoufi_marwa Thanks to @tobias.koetter’s hint there is an easy way to get the latest H2 and SQLite drivers and open up the world of window functions.

> [@SQLITE and Window Functions](https://forum.knime.com/t/sqlite-and-window-functions/31608/4):
>
> @tobias.koetter thank you for this hint this opens up the whole world of [window functions](https://www.h2database.com/html/functions-window.html#rank). I downloaded the latest JAR file from the [Maven site](https://mvnrepository.com/artifact/com.h2database/h2) and told KNIME where to find the driver. @khatuaani now you can benefit from the latest developments with H2 (and [SQLite](https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc)).

---

_[View the full topic](https://forum.knime.com/t/rank-variable-in-db/30564)._