Largest

Get nth largest value as a column

What It Does

Largest adds a column containing the Nth largest value from a numeric column. N=1 gives the maximum, N=2 the second largest, etc.

How to Use It

Opening the Panel

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

Configuration

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

SQL Generated

SELECT *, NTH_VALUE(price, 1) OVER (ORDER BY price DESC) AS max_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