select top 50 *
from
(SELECT TOP 1050 A.SPP,A.CPP FROM SPP_TT A INNER JOIN CPP_TT B ON A.ID=B.ID ORDER BY A.SPP ASC,B.CPP DESC)t
order by SPP desc,CPP asc
from
(SELECT TOP 1050 A.SPP,A.CPP FROM SPP_TT A INNER JOIN CPP_TT B ON A.ID=B.ID ORDER BY A.SPP ASC,B.CPP DESC)t
order by SPP desc,CPP asc
*
from
(select row=row_number()over(order by A.SPP ASC,B.CPP DESC),A.SPP,A.CPP
FROM SPP_TT A
INNER JOIN CPP_TT B ON A.ID=B.ID )t
where
row between 1001 between 1050