Logo

Dev blog by Ilya Ordin 👨‍💻

AllSQLPostgreSQL

How to get N rows per group in SQL

Let's assume that you are developing the home page in an online store. This page should display product categories with 10 products in each. How do you make a query to the database? What indexes do you need to create to speed up query execution?

How to get N rows per group in SQL