Saludos
Cita:
|
Empezado por Abel Garcia
Two Gotchas with SELECT FIRST
1. This
delete from TAB1 where PK1 in (select first 10 PK1 from TAB1);
[font=Trebuchet MS][size=2] will delete all of the rows in the table. Ouch! the sub-select is evaluating each 10 candidate rows for
deletion, deleting them, slipping forward 10 more...ad infinitum, until there are no rows left.
[le |
CHANFLEE!!
No sabia. Nunca se me habia presentado el caso de borrar los 1ro tantos de un registro.
Seria interesante que alguien nos dijera como se podria hacer en sentencias.