海纳百川有容乃大，壁立千仞无欲则刚

摘要： 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 阅读全文