67,513
社区成员
发帖
与我相关
我的任务
分享
SELECT b.id,b.name,b.year,b.point FROM (SELECT id,NAME,YEAR,POINT FROM stu WHERE YEAR='2008')a,(SELECT id,NAME,YEAR,POINT FROM stu WHERE YEAR='2009') b
WHERE a.name=b.name AND (b.point*1.0/a.point)>=1.0 AND (b.point*1.0/a.point)<=3.0