select typeName,bookName from(select * from BookDirectory a inner join BookClassification b on a.typeID= b.typeID)order by lickQuantity desc group by typeName,bookName having limit 0,2你可以试一把,是这个思路,我电脑没有mysql没运行,可能不对...
SELECT t.name,MAX(p.click),p.id,p.bookname,t.id AS tid FROM book AS P LEFT JOIN `type` AS t ON p.typeid = t.idGROUP BY p.typeid ORDER BY t.id,p.click DESC...