日期:2014-05-18 浏览次数:20640 次
--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