in reply to Re: Get top N rows in each group with DBIx::Class
in thread Get top N rows in each group with DBIx::Class

Hi NetWallah, thanks for your reply. If I understand correctly rows basically implements a LIMIT on the query, which isn't quite what I need here. I'm looking for a limit per artist, or, maybe a better example, I want to query for all tracks in the library but limit the results returned to N per CD.

On a related note, can you say when it's best to use the rows attribute on a search() call, and when it's best to use a slice() call instead?


The way forward always starts with a minimal test.