摘要：
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里面性能稍好一点。View Code?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 wher 阅读全文