[問題] Linq 巢狀查詢
目前正在將手上的SQL查詢改寫成Linq
遇到巢狀查詢的問題一直轉不出來
還望板上的大大指點一下迷津
[問題描述]
資料表中有TimeStamp, Value兩個欄位
需要將查詢到的資料依照TimeStamp做累積
[SQL語法]
Select TimeStamp, (
Select SUM(Value)
From [Data] as E
Where E.TimeStamp >= D.TimeStamp
) as AccValue
From Data as D
Order by D.TimeStamp
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 218.161.107.155
※ 文章網址: https://www.ptt.cc/bbs/C_Sharp/M.1490624896.A.9FB.html
→
03/28 04:09, , 1F
03/28 04:09, 1F
→
03/28 04:11, , 2F
03/28 04:11, 2F
→
03/28 16:07, , 3F
03/28 16:07, 3F
![](https://i.imgur.com/wSqzEJ7.jpg)
推
03/28 19:47, , 4F
03/28 19:47, 4F
→
03/28 21:27, , 5F
03/28 21:27, 5F
→
03/28 21:28, , 6F
03/28 21:28, 6F
![](https://i.imgur.com/evi0Z7H.jpg)
推
03/28 22:25, , 7F
03/28 22:25, 7F
→
03/28 22:45, , 8F
03/28 22:45, 8F
→
03/29 00:42, , 9F
03/29 00:42, 9F
→
03/29 01:32, , 10F
03/29 01:32, 10F
→
03/29 01:33, , 11F
03/29 01:33, 11F
→
03/29 11:24, , 12F
03/29 11:24, 12F
![](https://i.imgur.com/SiumIBF.jpg)
→
03/29 21:00, , 13F
03/29 21:00, 13F
→
03/29 21:01, , 14F
03/29 21:01, 14F
→
03/29 22:16, , 15F
03/29 22:16, 15F