mysql: how to select top5 from groups?

Question

MySQL

There is a table:
id,name,otdel,money
-----------------
1,alex,it,1000
2,anna,callcenter,2000
3,anton,it,3000
etc.
You need to choose from each department the top 5 employees with the highest salary.
For one group, I can make a query select * from users group by otdel ordeer by money asc limit 3 or something like that ..
Please write a query with an explanation, otherwise I met solutions to such problems on the Internet, but I couldn’t comprehend it ..

Answer 1

Well, you have a ready request

Answer 2

I need to select the top 5 employees with the highest salary from all departments with one request.

Answer 3

Something like this, apparently:
select u.* from users as u
where u.id in (select top 5 id from users as u1 where u1.otdel=u.otdel order by u1.money desc)
order by u.otdel, u.money desc