摘要： 如下图数据用select top 8 * from info_fair_job where is_stop=0 and batch_id=49 order by quantity desc按company_id 去重复，取同一company_id下quantity最大值以下三种方按，其中第一种主法在sql2005里面性能稍好一点。1.select top 8 * from info_fair_job t where is_stop=0 and batch_id=49 and quantity = (select max(quantity) from info_fair_job where co 阅读全文