分页： offset 0 rows fetch next 10 rows only

select b.cp_id,c_id,cp_cId,c_confid,c_title,c_open,c_openType,c_startTime,c_endTime,cp_status,c_uId,c.u_name,d.DepName  from [dbo].[classroom] a, classProcedure b, s_User c ,s_Depart d  where a.c_id=b.cp_cId and a.c_uId=c.id and c.depId=d.ID  and c_uid in (select u.id from s_user u inner join s_depart d on u.depId = d.Id and u.depId = 10)  and cp_verifyRole = 8 and c_open = 1  and c_type = 0  and c_openType in (1,2,3)  and cp_status='0' order by  c_startTime desc offset 0 rows fetch next 10 rows only