Delete where not in top 16000.

[Transcend]

Hi everyone

I need some help with a delete query. Basically one of our applications uses an access database to run its reports off. The database is only a temporary one that gets populated on the fly.

I'm looking to be able to run a query like

delete from table
where tablerow not in
(select top 16000 tablerows from table)

There isn't a primary key on the table as it is just a dump of data.

Is this even possible?

Transcend

 

[Transcend]

Hi again, i also want to know if there is a way i can delete all rows except for the bottom 16000 ?

Transcend

 

[Transcend]

Ok completely ignore this question

sorry to have wasted anyones time!!

I'm going to create an index on the fly when the table is being populated

Sorry again

Transcend