JDBC adapter Update command with select

49 Views

Hi experts,

I am using

select top 100 from <table> where flag = 0.

with

update <table> set flag = 1.

it is updating all the records available in table with flag = 1.

I need to update only records, which I have picked.

How I can do this ?