HF RL Explorer

Task: Run a PostgreSQL Query with LIMIT/OFFSET and Get Total Row Count Simultaneously

Task: Run a PostgreSQL Query with LIMIT/OFFSET and Get Total Row Count Simultaneously: a task in Terminal-Lego-15k (Harbor dataset). Create a PostgreSQL solution that retrieves paginated results (using LIMIT and OFFSET ) while simultaneously returning the total number of matching rows in a single…

The task

Create a PostgreSQL solution that retrieves paginated results (using `LIMIT` and `OFFSET`) while simultaneously returning the total number of matching rows in a single query. This is a common requirement for building paginated APIs and UIs.

Part of PrimeIntellect/Terminal-Lego-15k.