SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE ExamResult (StudentName VARCHAR(70), Subject VARCHAR(20), Marks INT ); INSERT INTO ExamResult VALUES ('Lily', 'Maths', 65 ); INSERT INTO ExamResult VALUES ('Lily', 'Science', 80 ); INSERT INTO ExamResult VALUES ('Lily', 'english', 70 ); INSERT INTO ExamResult VALUES ('Isabella', 'Maths', 50 ); INSERT INTO ExamResult VALUES ('Isabella', 'Science', 70 ); INSERT INTO ExamResult VALUES ('Isabella', 'english', 90 ); INSERT INTO ExamResult VALUES ('Olivia', 'Maths', 55 ); INSERT INTO ExamResult VALUES ('Olivia', 'Science', 60 ); INSERT INTO ExamResult VALUES ('Olivia', 'english', 89 SELECT Studentname, Subject, Marks, ROW_NUMBER() OVER(ORDER BY Marks) RowNumber FROM ExamResult;