Re: Delete Only 50 rows from table

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. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list

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)