snippets.su
Облако тегов
Поиск
Get first 10 row and total rows from table
postgresql
SELECT stuff, count(*) OVER() AS total_count FROM table WHERE .... ORDER BY ... OFFSET 0 LIMIT 10