Post reply

select bottom

  • November 26, 2002 at 1:28 am

    #79189

    hi,

    my query must return the "last" n record, but "select bottom" not exists; is there another way ?

    Thanks,

    anakin

  • November 26, 2002 at 1:56 am

    #442394

    In order to get the top records you must be using the following syntax.....

    SELECT TOP n .......

    FROM.......

    ORDER BY [field]

    In order to get the 'last' records simply reverse the ORDER BY clause as follows......

    SELECT TOP n .......

    FROM.........

    ORDER BY [field] DESC

  • November 26, 2002 at 2:38 am

    #442396

    Thanks, it's right, easy question are always difficult question

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

You must be logged in to reply to this topic. Login to reply