select top 1 from your_table order by updatetime desc?
priceid userid updatetime title--按用户分组,将更新时间最晚的显示在前面 select * from tb order by userid,updatetime desc --按用户分组,每个用户5组最新内容,并按更新时间逆序排列:select * from tb t where updatetime in(select top 5 updatetime from tb where userid=t.userid order by updatetime desc) order by userid,updatetime desc
select a.userid,a.updatetime,b.priceid,b.title from ( select userid,max(updatetime) as updatetime from tb group by userid)a join b on a.userid = b.userid
select * from tb order by userid,updatetime desc --按用户分组,每个用户5组最新内容,并按更新时间逆序排列:select * from tb t where updatetime in(select top 5 updatetime from tb where userid=t.userid order by updatetime desc) order by userid,updatetime desc
from (
select userid,max(updatetime) as updatetime
from tb
group by userid)a
join b
on a.userid = b.userid