Smallest

Get nth smallest value as a column

What It Does

Smallest adds a column containing the Nth smallest value from a numeric column. N=1 gives the minimum, N=2 the second smallest, etc.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Smallest". It's in the Aggregate group.

Configuration

FieldTypeRequiredDescription
ColumnColumn select (numeric)YesThe numeric column to find smallest values in
NNumberYesRank position (1 = smallest)

SQL Generated

SELECT *, NTH_VALUE(price, 1) OVER (ORDER BY price ASC) AS min_price FROM data
Try this operation →

Notes

  • Null values are handled gracefully - operations skip or preserve nulls where appropriate.
  • You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
  • The SQL preview shows exactly what will execute - inspect it before applying.

Related Operations