22,206
社区成员
发帖
与我相关
我的任务
分享
select id,class_name,name,sex,age,cn=
(
select top 1 class_name
from release
where rosterid=roster.id
order by [years] desc,month desc
),
f_time=
(
select top 1 f_time
from release
where rosterid=roster.id
order by [years] desc,month desc
)
from roster
where userid=1012
select
a.id,a.class_name,a.name,a.sex,a.age,max(b.class_name), max(f_time)
from
roster a,release b
where
a.id=a.rosterid
group by
a.id,a.class_name,a.name,a.sex,a.age
select id,class_name,name,sex,age
,cn=c.class_name
,f_time=c.f_time
from roster a
outer apply (
select top 1 class_name ,f_time
from release b
where b.rosterid=a.id
order by b.[years] desc,b.month desc
) as c
where a.userid=1012