22,210
社区成员
发帖
与我相关
我的任务
分享
--1
select b.* from (
select sID
group by sID
having count(cID) = (select count(1) from Course)
) a inner join Student b on a.sID = b.sID
--2
;with t as (
select row_number() over (order by infoID) Row,infoID,infoTitle from Info
)
select * from t where Row>=100 and Row<120