create table [201_sqm](id int,prod_id int,quoteprice decimal(10,2),qutodate datetime)
insert into [201_sqm] select 59,659,2,'2008-4-29'
insert into [201_sqm] select 60,660,3,'2008-4-29'
insert into [201_sqm] select 61,661,2.3,'2008-4-29'
insert into [201_sqm] select 62,662,4.5,'2008-4-29'
insert into [201_sqm] select 65,660,3.5,'2008-4-28'
insert into [201_sqm] select 66,660,2.9,'2008-4-30'
select * from [201_sqm] t where not exists(
select 1 from [201_sqm] where prod_id=t.prod_id and qutodate>t.qutodate
)
