using TOP

[gap]

hello,



i got a query where i am counting the number of something and group the counts for each topic. now using TOP I'm just getting five rows at all and not five rows for each topic. I am also using ORDER BY DESC to get the highest values. how can i combine TOP and GROUP BY to get for each topic just five rows?

thanks for help,

gap

[orange]

Please show your query, and exactly what you are trying to accomplish.

[gap]

here is a query:

 SELECT TOP 5 t.topic, t.number, t.ID_WoS FROM 
(SELECT topic, ID_WoS, Count(ID_WoS) AS number FROM table GROUP BY ID_WoS, topic) AS t
ORDER BY t.topic ASC, t.number DESC;

i'm counting the ID_WoS and need to group it for ID_WoS and topic.
i tried different combinations to get the 5 highest numbers for each topic.

in the example query i am just getting 5 rows for the first topic and not for all of them.

hope its better to understand.

thanks,
gap

[orange]

A couple of things.

Number is a reserved word in Access and may cause you a problem.
Do you really have a table called table? That may also be a reserved word.

I'm still not clear on what you want to achieve. You are familiar with the data and the environment, the rest of us rely on you for info.

Here's a link to a response I gave recently on a question about Top 5

top 5 based on descending highest number of hospital visits.

http://www.access-programmers.co.uk/...d.php?t=214997

Good luck

[gap]

hi,
number and table were just an example in this query.

thank you for the link, it's close to what i was looking for. I will try to fix my query and in the worst case give more detailed informations.