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










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










    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










      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






      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

                    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

                    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

                    Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її