[SQL ] 如何利用SQL條件搜尋後計算時間
資料庫名稱:Microsoft SQL
資料庫版本:8.0
內容/問題描述:
請問各位,如圖
上面部分是資料表內容,請問能不能利用SQL搜尋出並計算成下面結果?謝謝
http://i.imgur.com/Qkrm3LM.jpg
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.27.5.119
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1441957795.A.9BC.html
推
09/13 19:18, , 1F
09/13 19:18, 1F
→
09/14 15:40, , 2F
09/14 15:40, 2F
→
09/14 15:41, , 3F
09/14 15:41, 3F
→
09/14 15:41, , 4F
09/14 15:41, 4F
→
09/14 15:41, , 5F
09/14 15:41, 5F
推
09/14 19:25, , 6F
09/14 19:25, 6F
推
09/15 16:22, , 7F
09/15 16:22, 7F
推
09/15 23:48, , 8F
09/15 23:48, 8F
→
09/15 23:48, , 9F
09/15 23:48, 9F
→
09/16 09:17, , 10F
09/16 09:17, 10F
→
09/16 09:17, , 11F
09/16 09:17, 11F
→
09/16 09:17, , 12F
09/16 09:17, 12F
→
09/16 09:17, , 13F
09/16 09:17, 13F
→
09/16 09:17, , 14F
09/16 09:17, 14F
→
09/16 09:17, , 15F
09/16 09:17, 15F
→
09/16 22:21, , 16F
09/16 22:21, 16F
→
09/16 22:21, , 17F
09/16 22:21, 17F
→
09/16 22:21, , 18F
09/16 22:21, 18F
→
09/16 22:21, , 19F
09/16 22:21, 19F
→
09/16 22:21, , 20F
09/16 22:21, 20F
推
09/16 23:27, , 21F
09/16 23:27, 21F
推
09/17 08:52, , 22F
09/17 08:52, 22F
→
09/17 08:54, , 23F
09/17 08:54, 23F
推
09/17 09:23, , 24F
09/17 09:23, 24F
→
09/17 09:23, , 25F
09/17 09:23, 25F
→
09/17 09:24, , 26F
09/17 09:24, 26F
Database 近期熱門文章
PTT數位生活區 即時熱門文章