[SQL ] 請問如何相減再 group 起來?
看板Database作者fantasywater (prepare myself)時間8年前 (2015/09/10 06:09)推噓0(0推 0噓 1→)留言1則, 1人參與討論串1/2 (看更多)
+-------+-------+--------+---------+
| att1 | att2 | in/our | time |
+-------+-------+--------+---------+
| A | B | in | 7:00 |
+-------+-------+--------+---------+
| C | D | out | 7:50 |
+-------+-------+--------+---------+
| A | B | out | 7:20 |
+-------+-------+--------+---------+
| C | D | in | 7:10 |
+-------+-------+--------+---------+
請問如何下 SQL 計算時間差再 group 起來呢..?
結果希望像下面這樣..苦手中..
+-------+-------+-------------------+
| att1 | att2 | time_diff |
+-------+-------+-------------------+
| A | B | 10 |
+-------+-------+-------------------+
| C | D | 40 |
+-------+-------+-------------------+
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.160.87.217
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1441836598.A.5D7.html
→
09/10 23:24, , 1F
09/10 23:24, 1F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 2 篇):