那这个呢?
SELECt userid, score, (SELECT COUNT(distinct u2.score) FROM fschema.mytab3 u2 WHERe u2.score > u1.score) + 1 AS position FROM fschema.mytab3 u1ORDER BY position

那这个呢?
SELECt userid, score, (SELECT COUNT(distinct u2.score) FROM fschema.mytab3 u2 WHERe u2.score > u1.score) + 1 AS position FROM fschema.mytab3 u1ORDER BY position