Скачать или смотреть SQL - RANK, DENSE_RANK, ROW_NUMBER (WINDOW FUNCTIONS) and PARTITION BY CLAUSE -Day18

‪@LearnWithRD0529‬

-----Table and Insert scripts for practice---------

create table students(
id number,
name varchar(100),
subject varchar(100),
marks number
);

insert into students values(1020,'JOE','SCIENCE','97');
insert into students values(1020,'JOE','MATHS','98');
insert into students values(1020,'JOE','ENGLISH','89');
insert into students values(1021,'MARK','SCIENCE','76');
insert into students values(1021,'MARK','MATHS','87');
insert into students values(1021,'MARK','ENGLISH','91');
insert into students values(1022,'CLARK','SCIENCE','97');
insert into students values(1022,'CLARK','MATHS','56');
insert into students values(1022,'CLARK','ENGLISH','80');
insert into students values(1023,'MITCHELLE','SCIENCE','78');
insert into students values(1023,'MITCHELLE','MATHS','70');
insert into students values(1023,'MITCHELLE','ENGLISH','80');