MS SQL Top Problem

[Mouta]

Hi, i want to make a query to get 5 news of 8 ignoring the first 3, i've made this code but the problem is when i have less than 3 news, TOP N becomes negative, can you help me?

Thanks in advance

SELECT * ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM (SELECT TOP
(SELECT COUNT(ID) - 3 AS Expr1
FROM Clube AS Clube_2) ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM (SELECT TOP (8) ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM Clube AS Clube_1
ORDER BY ID DESC) AS Expr2
ORDER BY ID) AS Expr3
ORDER BY ID DESC

[mikr0s]

--if your query is executed the expected way,
--the following might work:

SELECT * ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM (SELECT TOP
(SELECT CASE WHEN COUNT(ID) - 3 <= 0 THEN COUNT(ID) ELSE COUNT(ID) - 3 END AS Expr1
FROM Clube AS Clube_2) ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM (SELECT TOP (8) ID, Titulo, Breve, Artigo, Data, Autor, Foto, Categoria
FROM Clube AS Clube_1
ORDER BY ID DESC) AS Expr2
ORDER BY ID) AS Expr3
ORDER BY ID DESC

--HTH--

[rmiao]

Try with case clause to test count(id), specify a number when count(id) is less than 3.

[Mouta]

Thanks, it worked.