Thanks for ur equivalent query. Its working as expected.... using rowid will not be prob right....As long as its value is unique. Regards, Thiru.
On Sun, Apr 19, 2009 at 8:33 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > "thirunavukarasu selvam" > <gs.th...@gmail.com> wrote in message > news:5b5250670904190006h7faba51ejbd9c392c0584c...@mail.gmail.com<news%3a5b5250670904190006h7faba51ejbd9c392c0584c...@mail.gmail.com> > > I need a help in using update query along with limit option. > > I tried the following query > > update table-name SET status='1' where status='0' limit 2 > > status - column name. > > You could use this equivalent query with "standard" SQLite build: > > update tableName set status = '1' where rowid in > (select rowid from tableName where status='0' limit 2); > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
