# TOPK

```sql
TOPK(numExpr, N)
```

Returns the K highest 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 TOPK(id) 
FROM orders-events
```

*Output:*

```json
{
  "value": {
    "TOPK": [
      "ffd7c548-06bb-40e9-8aae-558be65c1e70"
    ]
  }
}
```