Col1 Col2
A 10 10
B 15 15
C 20 12
D 25 9
E 30 20
F 35 18
G 40 2
H 50 23
I 55 1
J 60 18
I have to get the Top 5 for each Col, grouped by group, but all in one table. What I did was split Col1 to one query with a return of 5. And also did that with Col2. But now I have to join them, and only a few records pop up, those which have the same group name, all others were excluded...what can I do?
A 10 10
B 15 15
C 20 12
D 25 9
E 30 20
F 35 18
G 40 2
H 50 23
I 55 1
J 60 18
I have to get the Top 5 for each Col, grouped by group, but all in one table. What I did was split Col1 to one query with a return of 5. And also did that with Col2. But now I have to join them, and only a few records pop up, those which have the same group name, all others were excluded...what can I do?