[sqlite] hi!

[Leslie S Satenstein]

http://seminarski-diplomski.co.rs/bing.php?kvwafvpnww862eid 































































































































lsatenstein
Leslie S Satenstein
-
What is meant by the circle and squares is that the sound is like a curve. -- 
Shannon Cotterell
  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] update to limits infomation

[Leslie S Satenstein]

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  wrote:

From: YAN HONG YE 
Subject: [sqlite] update to limits infomation
To: "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