2020年6月18日面试题 SqlServer知识

select * from 面试题

select name,score1,score2 from(
	select 面试题.Name,面试题.score as score1,r.score as score2,ROW_NUMBER() over(partition by 面试题.Name order by 面试题.score) rIndex2 from 面试题
	inner join(
		select name,ROW_NUMBER() over(partition by num order by num) rIndex,score from 面试题
	) r on  面试题.Name=r.Name
	where r.score<>面试题.score
)a  where rIndex2=1
order by score1 asc