SQL interview_求第二大数对应的信息

一张表A，表中有两列，一列name,另一列为score,求score第二高的name?

 

a	10
b	20
c	30
d	40
e	50
c	60
NULL	NULL

 

SELECT TOP 1 * FROM

(

SELECT TOP 2 * FROM [dbo].[A]

ORDER BY Score DESC

) as Fact

ORDER BY Score ASC

 

name score
e          50