Is it possible to do this with one sql query?

Question

MySQL

There are authors of materials.
Each author has several entries.
It is necessary to make a query so that n records are selected for each author (if there are fewer, then how many there are).
I know how to do this in several requests, but in one it does not work.
I thought in the direction of GROUP_CONCAT, but you cannot impose a condition on it to limit the number of selected elements. Is it even possible?
Thank you all for your help!

Answer 1

Selecting the last few entries in some groups

Answer 2

here is a similar question

Answer 3

Sometimes it is more efficient to pre-number user records in a separate field (once the old data and then renumber them again when adding and deleting records), then the query becomes very simple:

select * from статьи t where t.номер<=:limit

Answer 4

It is possible But the decision with several requests from the client will be much more productive. Perhaps there is another way to apply the trick with variables ...
select * from статьи t
where :n > (select count(*) from статьи s where s.автор = t.автор and s.id<t.id)