1.select * from 表A A where
(select count(1) from 表A B where a.listID=b.listID and a.addDate>b.addDate)<12.select * from 表S where score>(select avg(score) from 表S where classID='本班')
and classID <>'本班'
(select count(1) from 表A B where a.listID=b.listID and a.addDate>b.addDate)<12.select * from 表S where score>(select avg(score) from 表S where classID='本班')
and classID <>'本班'
from 表A)
2. select * from 表S a where score >
(select avg(score) from 表S where classID=a.classID group by classID)
select ID,max(addDate) from a group by ID
第一个是不是这样的
2. select * from 表S a where score > (select avg(score) from 表S where classID=a.classID group by classID)
第二题楼上不对么?