Select t1.* 

from record t1 

join  record t2 on  t1.name=t2.name and dateadd(day,1,t1.date)=t2.date

join  record t3 on  t2.name=t3.name and dateadd(day,1,t2.date)=t3.date

试试这个行不行