-- 使用ROW_NUMBER排名 SELECT name, city, age, ROW_NUMBER() OVER (ORDER BY age DESC) AS rank_num FROM users; -- 按分组排名 SELECT name, city, age, RANK() OVER (PARTITION BY city