Skip to main content
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.

FunctionWhat it does
KATER__IS_IN_TOPTrue where the value ranks in the top count of the query’s rows, ties included.
KATER__IS_IN_BOTTOMTrue where the value ranks in the bottom count of the query’s rows, ties included.