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:[email protected] alternative: [email protected] www.itbms.biz www.eclipseguard.com --- On Mon, 2/4/13, YAN HONG YE <[email protected]> wrote: From: YAN HONG YE <[email protected]> Subject: [sqlite] update to limits infomation To: "[email protected]" <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
