SqlServer basic series-- row_number () rank () dense_rank () SqlServer series notes
create table A
(
Id int identity,
Name char(10)
)
create table B
(
Id int,
[SubJect] char(10),
Score int
)
--1. Search for the number of the top two in each subject No Name Subject Score
select * from (SELECT *,rn=ROW_NUMBER() OVER(PARTITION BY subject ORDER BY score desc)
FROM B) t where t.rn=3 AND a.rownum
