goody9807

摘要： [代码]题目一、取出 A类中price最大的记录select cate,max(price) from t group by cate如果要用分组，只能取出两列，要把所有的列都显示出来后来想到用overselect id,des,price from (select *,max(price) over(PARTITION by cate) as newprice from t ) a where ... 阅读全文