Count number of rows in a table

jefferis · November 29, 2021, 11:21pm

Hello,
I’m trying to integrate a self hosted seatable into a combined interactive and analytics workflow. I am using the python API (wrapped via R+reticulate). So far I am pretty happy, but there are still some things that I find surprisingly hard to figure out. One is to count the number of rows in a table. It seems that SQL COUNT() does not work when using the query method. Is there a quick way to count the number of rows in a table?
With many thanks,

Greg Jefferis.

daniel.pan · November 30, 2021, 2:28am

You can use count(*) like

select count(*) from table_name

jefferis · December 1, 2021, 2:36pm

Thank you very much. I can confirm this now works. I think SQL COUNT() did not work on earlier versions of the developer edition.

system · December 3, 2021, 2:37pm

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.