求条SQL

[xing527640118]

数据如下
id name date
1 AA 2008-12-02
2 BB 2008-12-03
3 CC 2008-12-02
4 DD 2008-12-05
5 EE 2008-12-08
6 FF 2008-12-01
我想抽取最新3条数据（根据日期）中的其中随机一条数据!比如:
4 DD 2008-12-05

[dawugui]

select top 1 * from
(
select top 3 * from tb order by date desc
) t
order by newid()

[百年树人]

select top 1 *
from (
select top 3 * from tb order by date desc) t
order by newid();

[dawugui]

create table tb(id int,   name varchar(10),     date datetime)
insert into tb values(1 ,     'AA' ,   '2008-12-02') 
insert into tb values(2 ,     'BB' ,   '2008-12-03') 
insert into tb values(3 ,     'CC' ,   '2008-12-02') 
insert into tb values(4 ,     'DD' ,   '2008-12-05') 
insert into tb values(5 ,     'EE' ,   '2008-12-08') 
insert into tb values(6 ,     'FF' ,   '2008-12-01') 
go

select top 1 * from
(
  select top 3 * from tb order by date desc
) t
order by newid()

drop table tb

/*
id          name       date                                                   
----------- ---------- ------------------------------------------------------ 
4           DD         2008-12-05 00:00:00.000

（所影响的行数为 1 行）
*/