Select last 1000 rows in Table

[saw15]

How do you reverse this:

select top 300 * from table

But instead of the top 300, I want the last 300. The field is not an integer so I can't use a subtraction calculation.

Any help is appreciated.

 

[sunila7]

Hi,

If ur field is ordered by say field1
select top 300 * from table order by field1 ASC

then

select top 300 * from table order by field1 desc

will give u the last records to appear for the order by criteria.

Sunil

 

[SQLBill]

Sunil is correct, but you only need to run the second script (the one with the ORDER BY column DESC), not the first one.

-SQLBill