数据库结构
业务需求:根据不同的原材料类型,比如化纤或者原料,找出这一类最新的一条数据,只需要一条。
select
MAX(price_create_time) AS price_create_time,
price_id as priceId,
price_name as priceName,
price_date as priceDate
FROM
t_weave_price
where
price_date =