# BOTTOMK

```
BOTTOMK(numExpr, N)
```

Returns the last K lowest ranked values. The ranking is based on how many times a value has been seen.

Available in:

| Processor (stateless) | Processors (stateful) | SQL Studio |
| --------------------- | --------------------- | ---------- |
|                       |                       | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT BOTTOMK(total) 
FROM orders-events
```

*Output:*

```json
{
  "value": {
    "BOTTOMK": [
      10.14
    ]
  }
}
```