Count rows in the select result

Get Help
1

Hi
Can you, please, help me? I can't find an answer to the following question:
How can I count how many rows my select returned?
I just wanna know how little changes in my 'select' statement affect the result without downloading an 'xlsx' file

2

Hi @Aleksandr
It's difficult to say without knowing your query.
If it is SQL, then you can do something like select count(*) from (select ...your statement)

3

yes, SQL =)
thanks for this, I did't know that
but is there any option to not change the query by adding the new "select count() from (select...))

4

@Aleksandr You can use the SQL question as a Saved Question and just use the interface to summarize:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#picking-your-starting-data

1 Like