我建了一个表    编号id    电影name    出品年份releasedyear    票房boxoffice
我想在这个表中按照出品年份找出当年票房最多的电影，同时也要显示id和name

select releasedyear,max(boxoffice) from film
group by releasedyear做不到后面的要求

select A.id,A.name,B.boxoffice from tb A,
  (select relesedyear,max(boxoffice) boxoffice from tb group by relsedyear) B
where A.relesedyear = B.relesedyear

--try again
select id,name,relesedyear,max(boxoffice)
from tb
group by id,name,relesedyear

group by 后面有多个字段,它是怎么来分组的.....