Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Convert sql to M

Hello All,   How do I write below sql into M query:   select sum(Sales) over (aprtiton by Country, State) from emp;   select count  (empid) over() from emp2;   Thanks, Aditya
Need Help
Show and Tell
JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hey Anonymous ,

 

I would rather do this. And it would be better to do it like this according to this link.

 

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    NO, I would like to know how this works

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      6 years ago

      I need to apologize Anonymous 

       

      I thought you wanted to have the optimal solution to your problem.

       

      But if you want to know how to do this technically, then I can refer you to this link.

       

      The principle is the same as yours.

       

      If this post was helpful may I ask you to mark it as solution and give it some kudos?

      Have a nice day!

      BR,
      Josef

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        In the example shown it is a Row number, I need a sum

        (Sum of the entire column, Example:  sum(sales) Over( order  by  year) 

         

        , I have tried it but unable t get it. Can you please show through an example 

         

        Greg_Deckler