假如表名为TB,数据列是SJ:
SELECT (SELECT COUNT(*) + 1 FROM TB WHERE SJ > t.SJ) AS ID, SJ FROM TB t ORDER BY SJ DESC
如果要替换列值,前面只要再加上update等相关的语句就行。