Limit Rows
Keep only the first N rows
What It Does
Limit Rows keeps only the first N rows. Optionally sort by a column first to get the top/bottom N by value.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Limit Rows". It's in the Filter & Sort group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Number of rows | Number | Yes | How many rows to keep |
Sort by | Column select | No | Column to sort by before limiting |
Sort direction | Select | No | ASC or DESC |
SQL generated under the hood
SELECT * FROM data ORDER BY revenue DESC LIMIT 100Related Operations
- Filter - Show only rows matching conditions
- Top / Bottom Rows - Show top or bottom N rows by column value
- Remove Duplicates - Remove duplicate rows