我得到了這張桌子
------ ------------------ ----------- -----------
| Name | Time | LowPrice | HighPrice |
------ ------------------ ----------- -----------
| #AAA | 12/13/2021 17:12 | 383.12 | 393.9 |
| #BBB | 12/13/2021 17:13 | 1110.34 | 1114.1 |
| #AAA | 12/13/2021 17:13 | 384.15 | 399.2 |
| #BBB | 12/13/2021 17:14 | 1112.34 | 1119.1 |
------ ------------------ ----------- -----------
和這個查詢：
SELECT "Name", "Time", "LowPrice", "HighPrice"
FROM rp_prices
WHERE "Time" > NOW() - INTERVAL '10 day';
我只需要得到一個價格，我認為是平均價格，并按天分組，就像這樣
------ ------------- ----------- -----------
| Name | Time | LowPrice | HighPrice |
------ ------------- ----------- -----------
| #AAA | 12/13/2021 | 383.12 | 393.9 |
| #BBB | 12/13/2021 | 1110.34 | 1114.1 |
------ ------------- ----------- -----------
謝謝你的幫助
uj5u.com熱心網友回復：
SELECT "Name", date_trunc('day', "Time"), avg("LowPrice"), avg("HighPrice")
FROM rp_prices
WHERE "Time" > now() - interval '10 day'
GROUP BY "Name", date_trunc('day', "Time")
uj5u.com熱心網友回復：
就像是
SELECT "Name", "Time",
min("LowPrice") as min_lp,
max("HighPrice") as max_hp,
avg("LowPrice") as avg_lp,
avg("HighPrice") as avg_hp,
avg(("HighPrice" - "LowPrice")/2) as avg_middle
FROM rp_prices
where "Time" > now() - interval '10 day'
group by "Name", "Time";
可能會給你你正在尋找的答案。允許在 Group By 子句中使用函式。如果“時間”列的精度高于天數，則可以使用它們
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/380034.html
標籤：sql PostgreSQL的