;with Pagetab2 as
(
;with Pagertab as
(
select a.course_id,a.course_name, sum(b.active_time) as total from User_Course_reg b,courseware a
where a.course_id=b.course_id and a.course_name like + '%' + @name + '%'
group by b.COURSE_ID,a.course_name
)
select row_number() over(order by course_id) as Rid, * from Pagertab
)
select * from Pagetab2 where RId between (@pageIndex - 1) * @pageSize and @pageIndex * @pageSize
这样能够嵌套不?
(
;with Pagertab as
(
select a.course_id,a.course_name, sum(b.active_time) as total from User_Course_reg b,courseware a
where a.course_id=b.course_id and a.course_name like + '%' + @name + '%'
group by b.COURSE_ID,a.course_name
)
select row_number() over(order by course_id) as Rid, * from Pagertab
)
select * from Pagetab2 where RId between (@pageIndex - 1) * @pageSize and @pageIndex * @pageSize
这样能够嵌套不?
SELECT * FROM TB
)
,T2 AS (
SELECT * FROM T1
)
,T3 AS (
SELECT * FROM T2
)
;WITH T1 AS (
SELECT * FROM TB
)
,T2 AS (
SELECT * FROM T1
)
,T3 AS (
SELECT * FROM T2
)
SELECT * FROM T3