By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t(nid INT);
INSERT INTO t(nid)
VALUES (1),(2),(3),(4),(5)
,(1),(2),(3),(4),(5)
,(1),(2),(3),(4),(5)
,(1),(2),(3),(4),(5);
Records: 20 Duplicates: 0 Warnings: 0
SELECT t.*, COUNT(*) OVER() AS cnt
FROM t
WHERE t.nid <1000
LIMIT 10
| nid | cnt |
|---|---|
| 1 | 20 |
| 2 | 20 |
| 3 | 20 |
| 4 | 20 |
| 5 | 20 |
| 1 | 20 |
| 2 | 20 |
| 3 | 20 |
| 4 | 20 |
| 5 | 20 |