22,210
社区成员
发帖
与我相关
我的任务
分享
select top 4 cu.UserBBName,cu.UserPhoto,cu.UserVotes,(select e.us from (select
a.userid,count(b.userid)+1 us from cm_users_tbl a left join cm_users_tbl b on
a.uservotes<b.uservotes group by a.userid) e inner join cm_users_tbl d on
e.userid=d.userid where d.userid=cu.UserID) as rank,gender=case cmu.gender when 1
then '男' else '女' end, Convert(varchar(20),datediff(Month,Birthday,getdate())/12)
+'岁'+ Convert(varchar(20),datediff(Month,Birthday,getdate())%12) + '个月' as
age,cv.UserId,convert(varchar(5),VisitAddtime,110)+' '+convert(varchar
(5),VisitAddtime,114) as VisitAddtime,VisitUserName,VisitUserId,VisitPhoto from
CM_Visitors_Tbl cv inner join cm_userinfo_tbl cmu on cmu.userid=cv.VisitUserId
inner join cm_users_tbl cu on cu.userid=cv.VisitUserId where cv.UserID=1972 order
by VisitAddtime desc
SELECT * FROM SH_Gallery_Tbl g inner join SH_Brand_Tbl b ON g.Brand_Id=b.Brand_Id
WHERE g.Gall_Id =
(SELECT MAX(Gall_Id)
FROM SH_Gallery_Tbl gg
WHERE gg.Brand_Id = g.Brand_Id) and cate_id=2
[code=SQL]select top 4 cu.UserBBName,cu.UserPhoto,cu.UserVotes,
(
select
count(b.userid)+1 us
from
cm_users_tbl b WHERE CU.uservotes<b.uservotes ) as rank,
gender=case cmu.gender when 1 then '男' else '女' end,
Convert(varchar(20),datediff(Month,Birthday,getdate())/12) +'岁'+ Convert(varchar(20),datediff(Month,Birthday,getdate())%12) + '个月' as age,
cv.UserId,
convert(varchar(5),VisitAddtime,110)+' '+convert(varchar(5),VisitAddtime,114) as VisitAddtime,
VisitUserName,
VisitUserId,
VisitPhoto
from
CM_Visitors_Tbl cv
inner join cm_userinfo_tbl cmu on cmu.userid=cv.VisitUserId
inner join cm_users_tbl cu on cu.userid=cv.VisitUserId
where cv.UserID=1972
order by VisitAddtime desc