RE: Delete Only 50 rows from table
what about this....
select unique_table_key, col_to_compare
from tabname a
where 50 >
(select count(*) from tabname b
where b.col_to_compare > a.col_to_compare )
order by col_to_compare desc
into temp temp_table_name with no log ;
delete from tabname where unique_table_key in (select unique_table_key from temp_table_name );
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of jayloub
Sent: Monday, March 21, 2005 3:16 PM
To: informix-list@iiug.org
Subject: Delete Only 50 rows from table
How can I delete only the top 50 rows of a table?
I can't seem to find any information on this! Please help!
sending to informix-list