求SQL~~最后出货信息

[gegeblue]

有很多相同料号,价格不同,出货日不同的数据
求最后出货时,料号和价格

select partno,price,createtime from table
后面怎么写?

[htl258_Tony]

select partno,price,createtime from tb t 
where createtime=(select max(createtime) from tb where  partno=t.partno)

[FlySQL]

select partno,price,createtime from [table] t 
where not exists(select 1 from [table] where partno=t.partno and createtime>t.createtime)

[无心雨云]

select partno,price,createtime from table a where createtime=(select max(createtime) from table where partno=a.partno)

[Rotel-刘志东]

select parto,price,creattime 
from tb t
where createtime=(select max(createtime) from tb where partno=t.partno)

[--小F--]

select
 partno,price,createtime 
from
 tb t 
where
 createtime=(select top 1 createtime from tb where partno=t.partno order by createtime desc)

[IceRiver_11]

declare @TABLE TABLE
(
partno VARCHAR(3),
price money,
createtime datetime
)


INSERT INTO @TABLE
SELECT '001',110,'2010-01-01'
UNION
SELECT '001',120,'2010-02-01'
UNION
SELECT '001',210,'2010-05-01'
UNION
SELECT '002',10,'2010-01-01'
UNION
SELECT '002',160,'2010-04-01'
UNION
SELECT '002',180,'2010-06-01'

select partno,price,createtime
from @table as a
WHERE NOT EXISTS (SELECT * FROM @TABLE WHERE partno = A.partno AND createtime >a.createtime )

select a.*
from @table as a
inner join ( select partno,max(createtime) as createtime from @table group by partno ) as b on a.partno=b.partno and a.createtime=b.createtime

[sych888]

select tt.partno,tt.price,tt.createtime
from
(select partno,price,createtime,rid=row_number() over (partition by partno order by createtime desc)
from tablename) tt
where tt.rid=1