SQL query How many points are ranked in the second place in class grades?

CREATE DATABASE KK;

Use KK;

CREATE TABLE Fenshubiao

(ID INT PRIMARY KEY auto_increment,

Mingzi VARCHAR (10),

Fenshu FLOAT

);

DESC Fenshubiao

INSERT into Fenshubiao VALUES (NULL, ' AA ', 95.0);

The first approach:

Select Max (Fenshu) as Second_fenshu from Fenshubiao WHERE fenshu< (select Max (Fenshu) from Fenshubiao); SELECT * from Fenshubiao;

The second approach;

Select Ifnull ((select DISTINCT Fenshu from Fenshubiao ORDER by Fenshu DESC LIMIT ), NULL) as Second_fenshu;

SQL query How many points are ranked in the second place in class grades?