I want to select the next record of a WHERE condition is met .
EG
REC DATA
10 Name1
20 Address1
30 Post1
10 Name2
20 Address2
30 Post2
Now my query is
select * from table where Data = 'Name1'
in the result I want REC20 and rec30 should also be displayed for Name1.