How do I query users with minimum value?

General
1

My users have some INT parameter. It’s incremented by some logic.
How do I write “where clause” expression to get 3 users with minimum values on this parameter on whole users table? It can be not the same value, but minimal in the table, like 1 3 7 when every other users is already beyond 100.
Thank you.

2

This should do it:

  1. use the sorting parameter to sort the table by the INT column in the ascending order
  2. set the pageSize to 3
3

Right. Thanks.