2022-11-23： 分数排名。输出结果和表的sql如下。请写出输出结果的sql语句？ +-------+------+ | score | rank | +-------+------+ | 4.00 | 1 | | 4.00 | 1 | | 3.85 | 2 | | 3.65 | 3 | | 3.65 | 3 | | 3.50 | 4 | +-------+------+

DROP TABLE IF EXISTS scores;
CREATE TABLE scores (
  id int(11) NOT NULL,
  score decimal(10,2) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO scores VALUES ('1', '3.50');
INSERT INTO scores VALUES ('2', '3.65');
INSERT INTO scores VALUES ('3', '4.00');
INSERT INTO scores VALUES ('4', '3.85');
INSERT INTO scores VALUES ('5', '4.00');
INSERT INTO scores VALUES ('6', '3.65');

答案2022-11-23：

sql语句如下：

select a.score as score,
(select count(distinct b.score) from scores b where b.score >= a.score) as rank
from scores a
order by a.score desc

在这里插入图片描述