|
Posted by vinci on 11/28/01 11:58
hai,
I have using sql2000 server i met one problem in upadate
query.
My table name is reserve
sno. cmname allocated
451 raja no
555 kumar yes
338 prabu no
224 mari no
993 arun no
330 makesh yes
This table having 200 records. I want to update first 20 "no" records
to update to "ye"
i am using this quer
update reserve set allocated='yes' from(select
allocated from reserve where allocated='no')
but this is not come exact answer please help this topic.
Thank u
Regards,
Vincent Manapparai.
Navigation:
[Reply to this message]
|