Select *
From (
      Select *, ROW_NUMBER() OVER (ORDER BY DateSend DESC) AS Num
      From News
      Where SubjectID in(Select MenuSubject.SubjectID
                         From MenuSubject inner join Menu on MenuSubject.MenuID = Menu.MenuID)
) as myTable
where myTable.Num BETWEEN 100 and 120

DECLARE @MyTable2 IntListTable
Insert Into @MyTable2
Select MenuSubject.SubjectID
From MenuSubject inner join Menu on MenuSubject.MenuID = Menu.MenuID
Select *
From (
      Select *, ROW_NUMBER() OVER (ORDER BY DateSend DESC) AS Num
      From News
      Where SubjectID in @MyTable2
) as myTable
where myTable.Num BETWEEN 100 and 120