二等奖:
select top 1 *
from Result
where id not in (select top 1 id
from Result
order by totalfens desc)
order by totalfens desc
三等奖:
select top 1 *
from Result
where id not in (select top 2 id
from Result
order by totalfens desc)
order by totalfens desc
select top 1 *
from Result
where id not in (select top 1 id
from Result
order by totalfens desc)
order by totalfens desc
三等奖:
select top 1 *
from Result
where id not in (select top 2 id
from Result
order by totalfens desc)
order by totalfens desc
第二名、select xh,cj from cjb where cj=(select max(cj) from cjb where cj<(select max(cj) from cjb))