Limit Rows Displayed from Database Table

I am pulling from a database table. Is it possible to limit the results.
For example, I want the first 10 rows sorted by Amount.

You"d sort the table by amount and set a filter condition like Count(1)<10.

Perfect, thank you. I wasn’t sure if count(1) was evaluated for each row or at the end of the query

1 Like