how to calculate sum of selected entries of a column in Magento 2How to join a calculated column from a table to collectionCopy Reviews from website_id 1 to website_id 2Move SKU numbers to custom attribute and clear SKU afterwards for all products (SQL)Magento 2 : Delete products having no name using sql or adminWhere is product price list column in databse?convert sql query to magento collectionHow to change a Mageto SQL in charge of loading the products when viewing a category pageSupplier,Brand,Category Name fetch of all products from sql ? magento2In how many tables, product custom attribute entries saved?How to get sum of rows of different id's at a time?

How much character growth crosses the line into breaking the character

Lowest total scrabble score

How to implement a feedback to keep the DC gain at zero for this conceptual passive filter?

Why is it that I can sometimes guess the next note?

Is there a working SACD iso player for Ubuntu?

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

Should I stop contributing to retirement accounts?

What is the evidence for the "tyranny of the majority problem" in a direct democracy context?

What is this called? Old film camera viewer?

Is it better practice to read straight from sheet music rather than memorize it?

How could a planet have erratic days?

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

How to indicate a cut out for a product window

A social experiment. What is the worst that can happen?

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

Is there a name for this algorithm to calculate the concentration of a mixture of two solutions containing the same solute?

Multiplicative persistence

It grows, but water kills it

Count the occurrence of each unique word in the file

Is there a single word describing earning money through any means?

Create all possible words using a set or letters

Why did the Mercure fail?

Store Credit Card Information in Password Manager?

copy and scale one figure (wheel)



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


How to join a calculated column from a table to collectionCopy Reviews from website_id 1 to website_id 2Move SKU numbers to custom attribute and clear SKU afterwards for all products (SQL)Magento 2 : Delete products having no name using sql or adminWhere is product price list column in databse?convert sql query to magento collectionHow to change a Mageto SQL in charge of loading the products when viewing a category pageSupplier,Brand,Category Name fetch of all products from sql ? magento2In how many tables, product custom attribute entries saved?How to get sum of rows of different id's at a time?













2















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






magento2 sql







share|improve this question




























    2















    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






    magento2 sql







    share|improve this question


























      2












      2








      2








      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






      magento2 sql







      share|improve this question
















      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






      magento2 sql




      magento2 sql






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 3 mins ago









      Shoaib Munir

      2,2231828




      2,2231828










      asked 13 mins ago









      Prince FBPrince FB

      162




      162




















          1 Answer
          1






          active

          oldest

          votes


















          0














          Query is simple, try this:



          SELECT SUM(total_purchase) AS 'sum_total_purchase' FROM table_name
          WHERE ref_by=1


          Try it, it will surely work.





          share






















            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

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Query is simple, try this:



            SELECT SUM(total_purchase) AS 'sum_total_purchase' FROM table_name
            WHERE ref_by=1


            Try it, it will surely work.





            share



























              0














              Query is simple, try this:



              SELECT SUM(total_purchase) AS 'sum_total_purchase' FROM table_name
              WHERE ref_by=1


              Try it, it will surely work.





              share

























                0












                0








                0







                Query is simple, try this:



                SELECT SUM(total_purchase) AS 'sum_total_purchase' FROM table_name
                WHERE ref_by=1


                Try it, it will surely work.





                share













                Query is simple, try this:



                SELECT SUM(total_purchase) AS 'sum_total_purchase' FROM table_name
                WHERE ref_by=1


                Try it, it will surely work.






                share











                share


                share










                answered 4 mins ago









                Shoaib MunirShoaib Munir

                2,2231828




                2,2231828



























                    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

                    Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

                    Image
                    In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice? "One can do his homework in the library" Setting correct UTM zone Time travel short story where dinosaur doesn't taste like chicken Do Bugbears' arms literally get longer when it's their turn? Offered promotion but I'm leaving. Should I tell? Subset counting for even numbers The difference between 時　and 時は String reversal in Python Good allowance savings plan? Do f-stop and exposure time perfectly cancel? What are some noteworthy "mic-drop" moments in math? They call me Inspector Morse Do I really need to have a scientific explanation for my premise? Make a transparent 448*448 image Could a cubesat propel itself to Mars? What is the chance of making a successful appeal to dismissal decision from a PhD program after failing the qualifying exam in the 2nd attempt? Could a cubesat be propelled to the moon? the return of Stri
                    Read more

                    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
                    iPad being using in wall mount battery swollen Should I cover my bicycle overnight while bikepacking? Do UK voters know if their MP will be the Speaker of the House? Why can't we play rap on piano? Plagiarism or not? Why didn't Miles's spider sense work before? How to tell a function to use the default argument values? Short story with a alien planet, government officials must wear exploding medallions If human space travel is limited by the G force vulnerability, is there a way to counter G forces? What about the virus in 12 Monkeys? Is it acceptable for a professor to tell male students to not think that they are smarter than female students? Avoiding the "not like other girls" trope? Apex Framework / library for consuming REST services Is there an expression that means doing something right before you will need it rather than doing it in case you might need it? Method Does Not Exist error message How to show a landlord what we have
                    Read more

                    How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

                    Image
                    Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create? Why isn't everyone flabbergasted about Bran's "gift"? Paektu / Changbai border dispute — why does the BBC shade a large area around the mountain? Is it OK if I do not take the receipt in Germany? How to ask rejected full-time candidates to apply to teach individual courses? /bin/ls sorts differently than just ls What *exactly* is electrical current, voltage, and resistance? Coin Game with infinite paradox Diffie-Hellman with non-prime modulus Example of a central simple algebra Etymology of 見舞い Lights are flickering on and off after accidentally bumping into light switch A journey... into the MIND How to calculate density of unknown planet? How to produce a PS1 prompt in bash or ksh93 similar to tcsh What's the connection between Mr. Nancy and fried chicken? How can I delete rows in the text? How is it possible to implement
                    Read more