这个简答的语句，请问这里错哪了，请求大佬指点

ivent 发布于 2018-11-25 14:41， 1509 次点击

只有本站会员才能查看附件，请登录

1 回复

mywisdom882018-11-28 22:18

select t1.* from students as t1 ,(select name,borndate from students where name like '%佳文%') as t2
where datediff(year,t1.borndate,t2.borndate)>=1