how to calculate sum of selected entries of a column in Magento 2

WiFi Thermostat, No C Terminal on Furnace

Is it safe to use olive oil to clean the ear wax?

Should I stop contributing to retirement accounts?

What should you do if you miss a job interview (deliberately)?

The IT department bottlenecks progress. How should I handle this?

What does chmod -u do?

How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby?

If infinitesimal transformations commute why dont the generators of the Lorentz group commute?

Electoral considerations aside, what are potential benefits, for the US, of policy changes proposed by the tweet recognizing Golan annexation?

Why did the Mercure fail?

250 Floor Tower

How much character growth crosses the line into breaking the character

why `nmap 192.168.1.97` returns less services than `nmap 127.0.0.1`?

What does routing an IP address mean?

If a character has darkvision, can they see through an area of nonmagical darkness filled with lightly obscuring gas?

Not using 's' for he/she/it

Which one is correct as adjective “protruding” or “protruded”?

Count the occurrence of each unique word in the file

Closed-form expression for certain product

How do I find all files that end with a dot

Delivering sarcasm

Removing files under particular conditions (number of files, file age)

Has any country ever had 2 former presidents in jail simultaneously?

How to bake one texture for one mesh with multiple textures blender 2.8



how to calculate sum of selected entries of a column in Magento 2














1















I want to calculate sum of all 'total_purchase' values whose 'ref_by' value is 1. Table name is 'table_name'. Can someone please help me.



I want sql query which will return total (200 + 97 + 140)



enter image description here






sql






share


























    1















    I want to calculate sum of all 'total_purchase' values whose 'ref_by' value is 1. Table name is 'table_name'. Can someone please help me.



    I want sql query which will return total (200 + 97 + 140)



    enter image description here






    sql






    share
























      1












      1








      1








      I want to calculate sum of all 'total_purchase' values whose 'ref_by' value is 1. Table name is 'table_name'. Can someone please help me.



      I want sql query which will return total (200 + 97 + 140)



      enter image description here






      sql






      share














      I want to calculate sum of all 'total_purchase' values whose 'ref_by' value is 1. Table name is 'table_name'. Can someone please help me.



      I want sql query which will return total (200 + 97 + 140)



      enter image description here






      sql




      sql





      share












      share










      share



      share










      asked 4 mins ago









      Prince FBPrince FB

      112




      112




















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267113%2fhow-to-calculate-sum-of-selected-entries-of-a-column-in-magento-2%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267113%2fhow-to-calculate-sum-of-selected-entries-of-a-column-in-magento-2%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

          Image
          What's the in-universe reasoning behind sorcerers needing material components? What killed these X2 caps? Why is consensus so controversial in Britain? CAST throwing error when run in stored procedure but not when run as raw query Assassin's bullet with mercury Why do bosons tend to occupy the same state? Ambiguity in the definition of entropy What does the expression "A Mann!" means Is it logically or scientifically possible to artificially send energy to the body? Do scales need to be in alphabetical order? Is there an expression that means doing something right before you will need it rather than doing it in case you might need it? Is it possible to create a QR code using text? Should I tell management that I intend to leave due to bad software development practices? Why no variance term in Bayesian logistic regression? How badly should I try to prevent a user from XSSing themselves? I would say: "You are another teacher", bu
          Read more

          Magento 2 disable Secret Key on URL's from terminal The Next CEO of Stack OverflowMagento 2 Shortcut/GUI tool to perform commandline tasks for windowsIn menu add configuration linkMagento oAuth : Generating access token and access secretMagento 2 security key issue in Third-Party API redirect URIPublic actions in admin controllersHow to Disable Cache in Custom WidgetURL Key not changing in Magento 2Product URL Key gets deleted when importing custom options - Magento 2Problem with reindex terminalMagento 2 - bin/magento Commands not working in Cpanel Terminal

          Image
          How to travel Japan while expressing milk? Is it correct to say moon starry nights? What exactly is ineptocracy? Is it a bad idea to plug the other end of ESD strap to wall ground? Is it OK to decorate a log book cover? logical reads on global temp table, but not on session-level temp table What did the word "leisure" mean in late 18th Century usage? How can I separate the number from the unit in argument? Is it possible to make a 9x9 table fit within the default margins? Can a PhD from a non-TU9 German university become a professor in a TU9 university? A hang glider, sudden unexpected lift to 25,000 feet altitude, what could do this? Does int main() need a declaration on C++? Is there a rule of thumb for determining the amount one should accept for a settlement offer? Why did early computer designers eschew integers? Early programmable calculators with RS-232 What does this strange code stamp on my passport mean? Why does the freezing point ma
          Read more

          Aasi (pallopeli) Navigointivalikko

          PallopelitLeikit pallolla Aasi on yksinkertainen pallolla pelattava pallopeli, joka toimii lasten ja nuorten ajanvietteenä. Peliin tarvitaan pallo ja kolme pelaajaa. Kaksi pelaajaa ovat kaukana toisistaan (noin 10m) ja kolmas pelaaja on heidän keskellään. Kaukaisimmat pelaajat heittelevät palloa keskenään, ja keskimmäinen pelaaja, aasi, yrittää siepata pallon itselleen. Jos aasi saa pallon kiinni, hän pääsee sen pelaajan paikalle joka heitti pallon. Tämä peli esiintyy myös nimillä Piimä , Mummonkiusaus ja Kala . lähde? Aasi on myös nimitys toiselle pallopelille. Peliin tarvitaan vähintään kaksi pelaajaa sekä pallo. Pelaajat päättävät järjestyksen, jossa pelaajat potkaisevat palloa jotain päin (esim. seinää). Kukin pelaaja potkaisee vuorollaan palloa, ja häviäjä on se, joka saa ensin sanan AASI. Kirjaimia saa sillä, että osuu palloon potkaisun jälkeen. Esim. Ville, Heikki ja Kalle pelaavat aasia. Ville potkaisee palloa, ja sitten on Heikin vuoro, mutta Ville osuu palloon ennen kuin
          Read more