Ms-Sql] 페이징 쿼리

select *

from (

select 

row_number() over(order by a.regDate desc) as rowNumber

, a.*

, b.OrderNo as OrderNumber

, c.GoodsTitle

from @DefaultData as a

left join t_order as b with(nolock)

on a.OrderUid = b.Uid

left join t_order_info as c with(nolock)

on b.Uid = c.OrderUid

where convert(varchar(8), a.regDate, 112) between convert(varchar(8), @startDate, 112) and convert(varchar(8), @endDate, 112)

) as tempTable

where tempTable.rowNumber between ((@currentPage -1) * @pageSize) + 1 and @currentPage * @pageSize