我有下表：
Date | Time | Value | ReceivedTime
2022-04-01| 00:59:59 | 5 | 00:30:15
2022-04-01| 13:59:59 | 15 | 13:30:00
2022-04-02| 21:59:59 | 5 | 21:30:15
2022-04-02| 22:59:59 | 25 | 22:25:15
2022-04-02| 23:59:59 | 25 | 23:00:15
2022-04-03| 14:59:59 | 50 | 00:30:15
2022-04-03| 15:59:59 | 555 | 00:30:15
2022-04-03| 16:59:59 | 56 | 00:30:15
我想與 Date,ReceivedTime 一起獲得最大值。
預期結果：
Date | Value | ReceivedTime
2022-04-01 | 15 | 13:30:00
2022-04-02 | 25 | 23:00:15
2022-04-03 | 555 | 00:30:15
uj5u.com熱心網友回復：
此答案假定，如果在給定的一天有兩條或更多條記錄被捆綁為相同的最高值，您希望保留一條記錄與最近的ReceivedTime. 我們可以DISTINCT ON在這里使用：
SELECT DISTINCT ON (Date) Date, Value, ReceivedTime
FROM yourTable
ORDER BY Date, Value DESC, ReceivedTime DESC;
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/478872.html
標籤：sql PostgreSQL
下一篇：SQL選擇所有關聯都沒有空值的行