Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: problem in select command

    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...

  • RE: problem in select command

    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...

Viewing 2 posts - 1 through 2 (of 2 total)