CREATE TABLE Students ( StudentID INT AUTO_INCREMENT PRIMARY KEY, Name VARCHAR(50), Score INT ); INSERT INTO Students (Name, Score) VALUES ('Alice', 90); INSERT INTO Students (Name, Score) VALUES ('Bob', 85); INSERT INTO Students (Name, Score) VALUES ('Charlie', 80); INSERT INTO Students (Name, Score) VALUES ('David', 75); INSERT INTO Students (Name, Score) VALUES ('Eva', 70); INSERT INTO Students (Name, Score) VALUES ('Frank', 65); INSERT INTO Students (Name, Score) VALUES ('Grace', 60); INSERT INTO Students (Name, Score) VALUES ('Henry', 55); INSERT INTO Students (Name, Score) VALUES ('Ivy', 50); INSERT INTO Students (Name, Score) VALUES ('Jack', 45); SELECT * FROM Students WHERE Score = ( SELECT DISTINCT Score FROM Students ORDER BY Score DESC LIMIT 1 OFFSET 2 );

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务