急！从SQL语句提取字段值，请大虾帮忙！

[qdubit]

我想从满足一些条件的两条记录中提取其中一条的字段值，怎么写SQL语句呀？
比如：
select top 2 xingming from table where xingbie='男' and nianling>'25' order by riqi desc
上面的语句中，我想得到第二条记录的xingming，怎么写呢？

[pbsql]

select top 1 xingming
from (select top 2 xingming from table1
where xingbie='男' and nianling>'25'
order by riqi desc) t order by riqi

[zjcxc]

select top 1 xingming from(
select top 2 xingming from table where xingbie='男' and nianling>'25' order by riqi desc)a order by riqi

[zjcxc]

--或者:
declare @xingming varcahr(8000)
select top 2 @xingming =xingming from table where xingbie='男' and nianling>'25' order by riqi desc
select @xingming

[Andy__Huang]

declare @s varchar(100)
set @s=''
select top 2 @s=@s+xingming+',' from table where xingbie='男' and nianling>'25' order by riqi desc

print left(@s,charindex(',',@s)-1)

[davorsuker39]

select top 1 xingming
from (select top 2 xingming from table1
where xingbie='男' and nianling>'25'
order by riqi desc) t order by riqi

[631799]

declare @s varchar(100)
set @s=''
select top 2 @s=@s+xingming+',' from table where xingbie='男' and nianling>'25' order by riqi asc--这里应该为asc.

print left(@s,charindex(',',@s)-1)

[631799]

declare @s varchar(100)
set @s=''
select top 2 @s=@s+xingming+',' from table where xingbie='男' and nianling>'25' order by riqi desc

print replace(right(@s,len(@s)-charindex(',',@s)+1),',','')

[631799]

print replace(right(@s,len(@s)-(charindex(',',@s)+1),',','')--少了个'('