取前10条无重复数据

如下:
  从Table中取出按按照UserID无重复的前10条数据,取出的字段还包括Name,Info字段.

 

select
 
top
 
10
 UserID,Name,Info


from


(

    
select
 
*
 

    
from
 

        (
select
 idd
=
row_number()
over
(partition 
by
 UserID 
order
 
by
 
getdate
()),
*


        
from
 
table
)t

    
where
 idd
=
1


)tt



Demo:



select top 4  UserID,SpaceName,ActivityTitle,case  when Picurl is null then 'images/default/user.jpg'  when picurl='' then 'images/default/event.jpg' else PicUrl end as PicUrl

from

(

    select * 

    from 

        (select idd=row_number()over(partition by a.UserID order by getdate()),a.userid,b.spacename,a.ActivityTitle,case  when c.Picurl is null then 'images/default/user.jpg'  when c.picurl='' then 'images/default/event.jpg' else c.PicUrl end as PicUrl

         from JY_D_Activity a left join JY_D_User b on a.UserID=b.UserID  left join JY_D_Userinfo c on a.UserID=c.UserID)t

    where idd=1

)tt