Request the last "n" rows

[PhilipL]

I know how to use the Top function but how can I retieve the last "n" records
from a table using "n" as a variable. I tried using a negative number but
that didn`t work.

Any advice or link is appreciated.

PhilipL

[PhilipL]

"PhilipL" <aplatfl@aol.com> wrote:
>
>I know how to use the Top function but how can I retieve the last "n" records
>from a table using "n" as a variable. I tried using a negative number but
>that didn`t work.
>
>Any advice or link is appreciated.
>
>PhilipL

I am using sql server 7 with vb.

[Chris Hylton]

order by the field you want to pick by (descending order) and still use top
N in your select statement...

Chris

"PhilipL" <aplatfl@aol.com> wrote:
>
>"PhilipL" <aplatfl@aol.com> wrote:
>>
>>I know how to use the Top function but how can I retieve the last "n" records
>>from a table using "n" as a variable. I tried using a negative number but
>>that didn`t work.
>>
>>Any advice or link is appreciated.
>>
>>PhilipL
>
>I am using sql server 7 with vb.

[srr]

Use
DECLARE @i INTEGER
SET @i = 10

SET ROWCOUNT @i

SELECT * FROM tbl ORDER BY DateField DESC
or

SELECT * FROM tbl
WHERE PK IN(SELECT * FROM tbl ORDER BY dateField DESC)
ORDER BY DateField ASC

SET ROWCOUNT 0

Play with this I think this is what you need.

Scott

"PhilipL" <aplatfl@aol.com> wrote:
>
>I know how to use the Top function but how can I retieve the last "n" records
>from a table using "n" as a variable. I tried using a negative number but
>that didn`t work.
>
>Any advice or link is appreciated.
>
>PhilipL