I have the following query:
SELECT TOP 3 * FROM Tabla1
WHERE [Grupo]=1
ORDER BY [Rank] DESC
UNION ALL
SELECT TOP 3 * FROM Tabla1
WHERE [Grupo]=2
ORDER BY [Rank] DESC;
The problem is that results for the first part Grupo = 1 are right, but for Grupo=2 are wrong. I mean, in ghe first case, I get the 3 records with highest [Rank] in Grupo=1, but not in the second case.
Any ideas to solve this are most welcome.
Thanks