On this page
Kater SQL Functions Top N
Top N
These conditions keep the rows of the result that rank highest or lowest.
Write them in QUALIFY, which filters the result after the query groups it.
| Function | What it does |
|---|---|
KATER__IS_IN_TOP | True where the value ranks in the top count of the query’s rows, ties included. |
KATER__IS_IN_BOTTOM | True where the value ranks in the bottom count of the query’s rows, ties included. |