您可以使用子查询来计算年龄较大的人数,例如:
select p1.*, ( select count(*) from People as p2 where p2.age > p1.age ) as AgeRankfrom People as p1where p1.Name = 'Juju bear'

您可以使用子查询来计算年龄较大的人数,例如:
select p1.*, ( select count(*) from People as p2 where p2.age > p1.age ) as AgeRankfrom People as p1where p1.Name = 'Juju bear'