Viewing 2 posts - 1 through 2 (of 2 total)
You may use below query to achieve the same result (if the query is running on SQL Server 2000 or order version)
---------------------------------
SELECT * FROM
(SELECT TOP 2 *
FROM DBO.NFFeeds
ORDER BY ID...
March 19, 2013 at 10:01 pm
#1598704
This can be achived by CTE.
1. First, declare CTE which will run same query with top 2 in decending order.
2. Select data from CTE with ID column in ascending...
March 18, 2013 at 9:50 pm
#1598279