SELECT row, *
from (select ROW_NUMBER() over( order by id) as Row, * from tablenamewhere tablename.msgtypeid=256 or aslogw.msgtypeid=8)
as tablename
where row>=1 and row<=5000
from (select ROW_NUMBER() over( order by id) as Row, * from tablenamewhere tablename.msgtypeid=256 or aslogw.msgtypeid=8)
as tablename
where row>=1 and row<=5000