DElete Top XXX Query

[GROG]

Hi all.. i have 200 record in my database.. and i want to delete the top 100 of them when i arrange it in ascending order.... btw i'm using ms access ..

The problem: what is the SQL instruction for this... can it be done?

Thanks in advance..:)

[lotus18]

Hi all.. i have 200 record in my database.. and i want to delete the top 100 of them when i arrange it in ascending order.... btw i'm using ms access ..

The problem: what is the SQL instruction for this... can it be done?

Thanks in advance..:)

Hi

You can post your thread at the Database > Access forum in whch they can assist you better : )

Rey Sean

[GROG]

Hi

You can post your thread at the Database > Access forum in whch they can assist you better : )

Rey Sean

Hi rey..

Thanks for the advice.. but i just need to know the sql code for the operation... i'll use it in my vb code.. to do the operation in my access databse.. i just want to make sure wether such operation can be done using sql code.. i think it can be done if i have the right code...

SELECT TOP 100 *
FROM Transact2
ORDER BY File_no DESC

if we were to retrieve top 100 data.. can we delete that top 100?

need some light... hmm

[jamesd0142]

not tested, but im sure its in the right area:

[code=sql]
delete from customers where cust_id in (select top 3 cust_id from customers)
[/code]

[GROG]

not tested, but im sure its in the right area:

[code=sql]
delete from customers where cust_id in (select top 3 cust_id from customers)
[/code]

Thanks james.. Will try..

[GROG]

Thanks james.. Will try..

hEY JAMES . Thanks a lot,.. tried and suceeded...

DELETE
FROM (SELECT TOP 1000 *
FROM Transact2
where Check_out IS NOT NULL
order by Check_in )


with a bit of alteration... u make my day..thanks again..