# Row\_number (or something analogous)

**URL:** <https://community.novulo.com/t/row-number-or-something-analogous/877>\
**Category:** \[Q&A\] General\
**Created:** [January 16, 2026, 8:40am UTC](https://community.novulo.com/t/row-number-or-something-analogous/877 "2026-01-16T08:40:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Axel\_Verkleij](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@Axel\_Verkleij](https://community.novulo.com/u/Axel_Verkleij)\
**Post date:** [January 16, 2026, 8:40am UTC](https://community.novulo.com/t/row-number-or-something-analogous/877/1 "2026-01-16T08:40:48Z")

</div>

Hi all, I am looking for an expression which numbers the output of a result set, identical to the SQL-function below:

> **[ROW\_NUMBER (Transact-SQL) - SQL Server](https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver17)**
>
> Transact-SQL reference for the ROW\_NUMBER function. This function numbers the output of a result set.

Is this already available in Novulo? If not, is this something that could be designed?

---

<div class="post-metadata">

**Author:** ![Redmer](https://yyz2.discourse-cdn.com/flex008/user_avatar/community.novulo.com/redmer/32/3_2.png) [@Redmer](https://community.novulo.com/u/Redmer)\
**Post date:** [January 21, 2026, 8:18am UTC](https://community.novulo.com/t/row-number-or-something-analogous/877/2 "2026-01-21T08:18:47Z")

</div>

Hey Axel,

We do not have a function (that i know of) that does this.  
You could however add a sum to your expression that counts all records in your query above the current one.

In this example we’re getting a set of user records.

**Expression**  
{  
users,  
\<int:sum({users,1,boolean:and([id.islower(parent.id)]),id.asc}).add(1),  
id,  
email\>,  
true,  
id.asc  
}

**Result**

 ![afbeelding](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/2X/a/a9fc5a34ec002c8f964c5fe57e459fe965a6f971.png)

Important here is that both sort expressions are the same.  
If you want the row number to start at 0 you can remove the “add(1)”.

Does this help you?