Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.