How to select the three entries with the highest number?

Question

PHP

Hello. There is a task like this
in the allianc table there is a dip field
there is a reqest table it has three fields uid and id time (int)
You must select from the reqest table the n-th number of records with the highest time
n-th number === the number from the dip field.
How to elegantly solve this problem?
thanks in advance

Answer 1

dig there - left join, max(time) as res, where res = dip. I think the meaning is clear.