bottom

Description

The bottom command limits the rows returned from a query to the last N rows in a given set, ordered by a specified expression. It is useful for finding the lowest-ranking values or least frequent occurrences within a dataset.

note

When using this command, pay close attention to your ordering expression, as it determines which records are considered "bottom" in the result.

Syntax

bottom <limit> <result_expression1> [as <alias>] [, <result_expression2> [as
<alias2>], ...] by <orderby_expression> [as <alias>]

Example

Use case: Get the least active usernames by activity

We want to identify which users interact with our system the least so we can focus on re-engagement or cleanup efforts.

Example data

{ "user": "Ariel", ... },
{ "user": "Ariel", ... },
{ "user": "Harel", ... },
{ "user": "Harel", ... },
{ "user": "Dana", ... }

Example query

bottom 10 user by count()

Example output

{ "user": "Dana", "count": 1 },
{ "user": "Harel", "count": 2 },
{ "user": "Ariel", "count": 2 }

The command returns the bottom 10 users based on event frequency. In this mock dataset, only three users exist, so all are shown, with "Dana" ranked lowest by activity count.