Top / Bottom Rows
Show top or bottom N rows by column value
What It Does
Top / Bottom shows the highest or lowest N rows. Similar to Limit but with explicit top/bottom mode selection.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Top / Bottom Rows". It's in the Filter & Sort group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Mode | Select | Yes | top or bottom |
Count | Number | Yes | Number of rows to show |
Sort column | Column select | No | Column to rank by |
SQL generated under the hood
SELECT * FROM data ORDER BY revenue DESC LIMIT 10Related Operations
- Filter - Show only rows matching conditions
- Limit Rows - Keep only the first N rows
- Remove Duplicates - Remove duplicate rows