6 Replies Latest reply: Apr 18, 2014 1:48 AM by anbu cheliyan RSS

    select on condition

    Anton sineok

      Hello (sorry do not speak in English)

      there is a table

       

      Checknum

      Price without discount

      Sum of Discounted

      discount Amount

      122444

      10

      8

      2

      122445

      15

      15

      0

       

       

      It is necessary to select only those checks which have discount and skip the checks that have no discount. And to calculate the amount of revenue these checks.

      (If it was possible, I would like to calculate the price and dishes that were in the checks which had a discount but for which the discount is not applied, but it is probably very difficult ..)

      Thank you very much for your help!