Re: Delete Only 50 rows from table

Posted in 2005

DA Morgan — Mon, 21 Mar 2005 16:34:08 -0800 — source: Usenet: comp.databases.informix

Obnoxio The Chav wrote: > jayloub said: > >>How can I delete only the top 50 rows of a table? >> >>I can't seem to find any information on this! Please help! > > > 1. Find the first 50 rows in a table. > 2. Delete them. top 50? first 50? These are heap tables aren't they? There is no such thing as top for first. What I'm hearing is arbitrarily delete any 50 rows because neither statement includes a defined condition. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)