Answer the question
In order to leave comments, you need to log in
Select first N records for each group, how does it work?
Faced with the classical task:
In the table one field - groups, another - values. You must select, say, three values for each group. It is necessary to implement in Access.
There is a working query on google like this:
SELECT Группа, Значение
FROM Таблица
WHERE Значение IN
(SELECT TOP 3 Значение
FROM Таблица as Temp
WHERE Temp.Группа= Таблица.Группа
ORDER By Значение DESC)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question