34,593
社区成员
发帖
与我相关
我的任务
分享
select * from T_INFO_CASEBASE
where
JSSJ in (select top 2 JSSJ from T_INFO_CASEBASE order by JSSJ desc )
--或者
select * from T_INFO_CASEBASE a,
(select top 2 JSSJ from T_INFO_CASEBASE order by JSSJ desc) b
where a.jssj = b.jssj