I have a table for eg.

```
        Id  FName  Lname  RowNo
       ----------------------------
        1   Aaron    K     0
        2   Aaron    L     1
        3   Arthur   M     2
        4   Arthur   G     3
        5   Arthur   D     4
        6   Ben      S     5
        7   Ben      E     6
        8   Cal      W     7
        9   Luke     A     8
        10  Mandy    N     9 

```

I have implemented pagination on this table hence the row number. but my problem is instead of getting 3 rows everytime i want to get all rows with 3 repeated values. for example first i want to get all rows with the names Aaron, Arthur,Ben i.e rows 0 to 6 then the next 3 repeated values eg cal, luke and mandy and so on. Is this possible in SQL????

--edit----
 i want 3 values wich can be repeated any number of times.let me explain better. if i applied Distinct() on Name column I would get, Aaron,Arthur,Ben the first time and then cal ,luke and mandy the second time. But as the last names are different I cannot apply distinct. so insetead to getting just the distinct values I need to get the all the rows with those distinct values.i.e all rows with Aaron,Arthur and ben the first time and all rows with cal, luke and mandy the 2nd time