选择最大值的那条记录 sql

select movieID,movieName,priceFactorM from TEST1 as a
where priceFactorM=(select max(b.priceFactorM)
from TEST1 as b

              );  
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: 点我我会动 设计师:白松林 返回首页