34,838
社区成员




select
partno,price,createtime
from
tb t
where
createtime=(select top 1 createtime from tb where partno=t.partno order by createtime desc)
select parto,price,creattime
from tb t
where createtime=(select max(createtime) from tb where partno=t.partno)
select partno,price,createtime from table a where createtime=(select max(createtime) from table where partno=a.partno)
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 tb t
where createtime=(select max(createtime) from tb where partno=t.partno)