11 Replies Latest reply: Aug 9, 2018 9:04 AM by Sunny Talwar RSS

    how to choose the product having maximum sales and expense

    Vikas NA

      hi everyone,

      i have a table t with

      product, sales and expense column, e.g

      t:

      Product, sales, expense

      1          ,  20,          ,30

      1          ,  40          ,30

      2          ,20           ,25

       

      now i want the name of the product whose expense is highest and is having the maximum sales....

      can anyone suggest me a way to do this

       

      thanks

      Vikas