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

4 Replies

  • 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