SELECT age,
(SELECT count(DISTINCT age) FROM ages WHERE age >= s.age) AS 'Rank'
FROM ages s
ORDER BY age DESC;
mysql 排序函数使用
最新推荐文章于 2022-04-13 21:08:55 发布
SELECT age,
(SELECT count(DISTINCT age) FROM ages WHERE age >= s.age) AS 'Rank'
FROM ages s
ORDER BY age DESC;