SELECT @max_price:=max(goods_price) from t_goods_norms where goods_id = 25; select * from t_goods_norms where GOODS_PRICE = @max_price; 临时变量定义方式:@name: