sql server - How to get cumulative sum -

- 

  @t तालिका घोषित करें (id int, SomeNumt int) @t select 1,10 union select 2 में डालें, 12 संघ का चयन 3,3 संघ चुनें 4,15 संघ चुनें 5,23 चुनें @ से

चुनें ऊपर दिए गए मुझे रिटर्न देता है। 

  आईडी कुछ नं 1 10 2 12 3 3 4 15 5 23

मैं निम्नलिखित कैसे प्राप्त करूं 

  id srome cumsrome 1 10 10 2 12 22 3 3 25 4 15 40 5 23 63   
 
 
  चुनें t1.id, t1 कुछ नॉट, एसयूएम (टी 2। कुछ न्यूमेट) टी 1 एआईटी से जुड़ते हैं, टी 1 एआईडी पर टीटीआई पर टी 1.आईडी & gt; = टी 2.आईड ग्रुप टी 1.आईडी, टी 1 द्वारा। टीओ.आईडी द्वारा क्रमबद्ध कुछ ऑर्डरः   
  
  आउटपुट   
  | आईडी | SOMENUMT | SUM | ----------------------- | 1 | 10 | 10 | | 2 | 12 | 22 | | 3 | 3 | 25 | | 4 | 15 | 40 | | 5 | 23 | 63 |  
 
  संपादित करें:  यह एक सामान्यीकृत समाधान है जो कि अधिकांश डीबी प्लेटफॉर्म पर काम करेगा। जब आपके विशिष्ट प्लेटफॉर्म (उदाहरण के गैरेथ के) के लिए बेहतर समाधान उपलब्ध होता है, तो इसका उपयोग करें!

Comments

Post a Comment

Popular posts from this blog

php - multilevel menu with multilevel array -

-
Just ask someone to solve this problem? I want to create a multilevel menu I can not find the right solution generated with multilevel array, it always gets an array_push error My study came from the original idea But still my Can not match the need. This is my MySQL [code] ----- --------------------- --------------- | ID | PARENT_ID | Name | Link | Seq | 1 | 0 | Dashboad | Dashboard / | 1 | 2 | 0 | Menu 1 | Menu 1 / | 2 | 3 | 0 | Menu 2 | Menu 2 / | 3 | 4 | 0 | Menu 3 | Menu 3 / | 4 | 5 | 2 | Joint Add / | 1 | 6 | 3 | Joint Add / | 1 | 7 | 2 | Edit | Edit / | 2 | 8 | 4 | Joint Add / | 1 ------------------------------------------ [/ Code] I want to do something like this in my array array ('dashboard' = & gt; array ('id' = & gt; '' 'Dame' = & gt; 'Dashboard', 'Title' = & gt; 'Dashboard', 'MatchMin' = & gt; Base_URL (). 'Dashboard /', 'Active' => = & Gt; NULL), ...
Read more

.net - C# List<T>.Find(x=>x.Rectangle.Contains(Point)) FAIL -

-
For my life, I can not understand why this code generates the following output ... I think there is a bug or something while using the list and lambda, if type one rectangle exposes the property and you use the included method of rectangle object ... and the clear statement proves true while Find list method fails .... Onway Code Public Gridskeyr Warldtokapadsb (Point location) {location = _Map.WorldToClient (location); Gridsquare gs = this.find (x => x.Rectangle.Contains (location)); GridSquare KP = G.Find (X => X. laxative canteen (location)); & Lt; GridSquare & gt; List = kp.FindAll (x => x.Rectangle.Contains (location)); U.dp (list.Count); Gridskare sub = KP.Fid (X => X. laxative canteen (location)); If (sub == faucet) {u.dp (place to look for "location"); U.dp ("The location found in the grid category" + GS toaster ()); U.dp ("Grid Square Bounds" + gs.Rectangle.ToString ()); U.dp ("location found in keypad" +...
Read more

objective c - iPhone and it's wireless area -

-
Is this a way to find other iPhones in the category of wireless areas? So I give an example. I'm staying at the airport somewhere I have an iPhone too. I and the other iPhone owners are playing the same game. Is there any way to warn me and the other player that we are close to each other? Does this work even if we are not on the same wireless network, or there is no wireless? And if there is any way to do this, can you give me some starting point? Like a link where I can learn something like this or maybe this is probably the name of this process, because I do not know how to search about this topic in Google. Thanks in advance! Can be completed with peer-to-peer discovery and connectivity you are describing Game Kit Framework Originally I thought it works only through Bluetooth, but after watching it immediately, it seems that WiFi is also supported. Hope it helps!
Read more