Since your table is small, you should clear out the rank column Then do a select
Regards Leslie Mr. Leslie Satenstein 50 years in Information Technology and going strong. Yesterday was a good day, today is a better day, and tomorrow will be even better. SENT FROM MY OPEN SOURCE FEDORA LINUX SYSTEM. mailto:lsatenst...@yahoo.com alternative: leslie.satenst...@itbms.biz www.itbms.biz www.eclipseguard.com --- On Mon, 2/4/13, YAN HONG YE <yanhong...@mpsa.com> wrote: From: YAN HONG YE <yanhong...@mpsa.com> Subject: [sqlite] update to limits infomation To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> Date: Monday, February 4, 2013, 8:22 PM I hava a table like this: id,name,score,rank 1,anna,80,0 2,qera,65,0 6,kero,90,0 10,rosa,95,0 what I would like to do is to update the rank position. I have this, update mytable set rank= 1 where max(score); update mytable set rank= 2 where max(score-1) ; .... .... the result should be like this: id,name,score,rank 1,anna,80,3 2,qera,65,4 6,kero,90,2 10,rosa,95,1 _______________________________________________ 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