UPDATE EE SET EE.年级名次=(SELECT COUNT(*)+1 FROM EE B WHERE EE.总分提示函数名缺少)。
UPDATE EE SET EE.年级名次=(SELECT COUNT(*)+1 FROM EE B WHERE EE.总分<B.总分) FROM EE