SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY idTag) as row FROM tblknowledgement ) a WHERE row > 5 and row <= 10