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

Indexing in SQL -

-
My table has 10 columns .... What column do I choose to create an index? Is there a guideline rule to do this? What are the disadvantages of indexes? What if I update the column which is part of the index? Does this reduce performance of INDEXES? from other posts: 1.1 You should make indexes on columns that are often used in the WHERE section. 1.2 You should be indexed on the columns you use repeatedly to come into the columns. 1.3 You should make indexes on columns that are often used 1.4 You get indexed on the columns The table should contain some of the same values ​​or unique values. 1.5 You should not index small tables (tables using only a few blocks) because a full table scan can be faster than the indexed query. 1.6 If more than one column is often used in the WHERE section in a converged index, then first create the most selected columns, pre-create in the index statement. 1.7 column has many nulls and you do not search for zero-value v...
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

unix - Listing all shared memory segments used by a process on AIX5.3+ -

-
I would like to find all the shared memory segments used by a given process I am particularly interested in detecting shmid That's why I can use it in call (shmctl). On Solaris I will just read / proc / $ PID / map to find that information (field pr_shmid) The content of that file is defined by struct prmap_t in the sys / procfs format. Ax also has a / proc / $ PID / map file. Any project is a primate, but unfortunately it has been projected in pr_shmid field. Any ideas how can I get it on AIX5.3 +? I do not particularly know about AX, but I think that ipcs command is quite standard where SysV IPC is supported, so I want to get the ipcs -m command to give the appropriate code; If you can not find a better method, then there may be an option to parse its output.
Read more