Re: Delete Only 50 rows from table

Obnoxio The Chav wrote: > Serge Rielau said: > > >>Note to OTC: To remove the top-n-rows is a typical opeation on a table >>serving as a queue. It's usually a destructive read. >>I do follow the why.... > > > Can you spell "bad application design"? > So hwo do you implement queue and to-do style data? What about an "outstanding orders" table? A staging table in a warehouse? Oustanding tickets in a support center? FIFO is not exactly an esoteric concept in IT. And even if this were "bad design" I have learned to roll with the punches. Can't make customers use the system the way I want it. Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab