并列排名UPDATE test0 a,(SELECTid,num,( SELECT COUNT( * ) + 1 FROM test0 c WHERE c.num > test0.num ) pm FROMtest0 ) b SET a.rank = b.pm WHEREa.id = b.id