|
假設(shè)采購記錄表為purchase_records，包含以下字段： - purchase_id：采購記錄ID - supplier_id：供應(yīng)商ID - product_id：產(chǎn)品ID - purchase_date：采購日期 - purchase_price：采購價格 以下是查詢某個時間段、某個供應(yīng)商、某個產(chǎn)品的價格趨勢的SQL語句： SELECT YEAR(purchase_date) AS purchase_year, MONTH(purchase_date) AS purchase_month, AVG(purchase_price) AS avg_priceFROM purchase_recordsWHERE supplier_id = 'xxx' -- 供應(yīng)商ID AND product_id = 'yyy' -- 產(chǎn)品ID AND purchase_date BETWEEN '2021-01-01' AND '2021-12-31' -- 時間段GROUP BY YEAR(purchase_date), MONTH(purchase_date)ORDER BY YEAR(purchase_date), MONTH(purchase_date)該SQL語句會按照年份和月份分組，計算出每個月的平均采購價格，并按照時間順序排序。你可以將xxx和yyy替換為具體的供應(yīng)商ID和產(chǎn)品ID，將時間段替換為你需要的時間段。 |
|
|
