我需要在限制搜索的基础上检索受影响的总行数 - Node / Express / SQL Server

I am creating pagination for one of my calls. I need to retrieve the total rows that would be affected regardless of the page selected. I also need to retrieve just the objects for that page only. It makes sense to create two queries. However, I'm unsure how to go about this because I keep getting back errors. I am creating pagination for one of my calls. I