Hi all, i was trying to implement these PostgreSQL query for getting N item with lowest price for each category the reference SQL is like SELECT tmp.category_id, tmp.product.* FROM ( SELECT row_number() over (partition by product.category_id order by product.price ASC), product.* as sort_number …

[image] csadewa: is there a better way? I don’t think so. You have to use plain structure. A simple map can be used instead of a struct, so you don’t put a virtual field to the schema, but actually it is the same approach.

Ecto Subquery for getting N item of Lowest amount grouped by category

Questions / Help

fuelen July 6, 2021, 7:47am 2

Here is a solution for a very similar topic

1 Like