Selecting next record from multiple records :SQL

72 Views Asked by At

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.

0

There are 0 best solutions below