> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lightdash.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Rank in column

> Ranking values in a column is when you set every value as a number either higher than or lower than the other values. The lowest value (rank = 1) indicates the value with the first rank in your set of values.

[Just gimme the code! <Icon icon="bug" iconType="solid" />](#here’s-the-sql-you-can-copy-paste-to-calculate-your-rank-in-column)

Here's an example of a percent change calculation:

<Frame>
  <img src="https://mintcdn.com/lightdash/XmMbfEv-H1Md5aR1/images/guides/table-calculations/table-calculation-sql-templates/rank-in-column-a1dfa61a36fcf3a7fd1b7906bc7abeb1.jpg?fit=max&auto=format&n=XmMbfEv-H1Md5aR1&q=85&s=3e4311af80412cd6347308080a50ac52" width="2818" height="1419" data-path="images/guides/table-calculations/table-calculation-sql-templates/rank-in-column-a1dfa61a36fcf3a7fd1b7906bc7abeb1.jpg" />
</Frame>

And here's the SQL used to generate it:

```sql theme={null}
ROW_NUMBER() OVER (
  PARTITION BY
    ${orders.order_date_month}
  ORDER BY
    ${orders.total_order_amount} DESC
)
```

In general, the SQL used for calculating the rank in a column has just one important column and one other important parameter:

* `column_i_want_to_rank` - this is the column that you want to rank
* `ASC` and `DESC` - if you want to have the **biggest values** with rank = 1, then you need to add `DESC` to your `ORDER BY` clause. If you want the **smallest values** with rank = 1 then you can add `ASC` to your `ORDER BY` clause (this isn't required, since the ordering is `ASC` by default).

### Here's the SQL you can copy-paste to calculate your rank in column

```sql theme={null}
ROW_NUMBER() OVER (
  ORDER BY
    ${table.column_i_want_to_rank} DESC
)
```