一张表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
一张表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