Get subset of rows through the slice

[Babubabu]

For example in a table there are 100 rows. In these, 30 rows belongs to current user, I want to get rows from 6 to 10 only. How can we get these rows?