Problema para pular resultados de consulta

[Berlan Barbalho 0]

Boa tarde, estou com um problema para conseguir pular os 4 primeiros resultados dessa consulta, ja tentei usar o ROW_NUMBER() para fazer isso mais não consegui fazer funcionar, alguém poderia da uma ajuda?

 

SELECT TOP 4 GuildMember.G_Name as G_Name, SUM(Character.Resets) as TotalResets, RANK() OVER(ORDER BY SUM(Character.Resets) DESC) as Rank
FROM MuOnline.dbo.GuildMember, MuOnline.dbo.Character
WHERE GuildMember.Name = Character.Name
GROUP BY GuildMember.G_Name
HAVING SUM(Character.Resets) >= 0
ORDER BY SUM(Character.Resets) DESC

 

 

Agradeço antecipadamente!

[marcio.theis 3]

Boa tarde.

 

Veja se desta forma é o que precisa:

 

SELECT *
FROM (
SELECT GuildMember.G_Name as G_Name, SUM(Character.Resets) as TotalResets, ROW_NUMBER() OVER(ORDER BY SUM(Character.Resets) DESC) as Rank
FROM MuOnline.dbo.GuildMember, MuOnline.dbo.Character
WHERE GuildMember.Name = Character.Name
GROUP BY GuildMember.G_Name
HAVING SUM(Character.Resets) >= 0
) AS LISTA
WHERE LISTA.RANK > 4

 

[Berlan Barbalho 0]

22 minutos atrás, marcio.theis disse:

Boa tarde.

 

Veja se desta forma é o que precisa:

 

SELECT *
FROM (
SELECT GuildMember.G_Name as G_Name, SUM(Character.Resets) as TotalResets, ROW_NUMBER() OVER(ORDER BY SUM(Character.Resets) DESC) as Rank
FROM MuOnline.dbo.GuildMember, MuOnline.dbo.Character
WHERE GuildMember.Name = Character.Name
GROUP BY GuildMember.G_Name
HAVING SUM(Character.Resets) >= 0
) AS LISTA
WHERE LISTA.RANK > 4

 

Funcionou perfeitamente, obrigado!