My question is as follows ... In my news page highlight has to appear the 2 latest news and on the secondary news page have to appear the 2 other news following. Example: in the highlight the news that will appear are the news 4 and 3, already in the secondary news to 2 and 1.
I thought of using the LIMIT but this command does not exist in SQL Server so I informed it is just from MySQL, I also thought about BETWEEN but the logic I used did not get any better, so I saw that Top does something similar to LIMIT , so in the highlighted I made the following command
SELECT TOP 2 * FROM CADNOTICIAS ORDER BY CODIGO DESC
In this beautiful highlight is what I want, is returning perfect, my question and how to do in the secondary news bring the news 2 and 1. Everything has to be dynamic in the case of adding a news 5 on the page highlight show news 5 and 4 and in the secondary notice shows 3 and 2.