8 Replies Latest reply: Apr 2, 2013 2:42 AM by Girish Sharma RSS

    pls i need your help in my SQL Query statement

      Hi brothers

      pls guys i need some one help me about this Question

      List all columns of all rows in the STOCKITEM table in ascending primary key sequence.
      Only list rows where the selling price is greater than the purchase price multiplied by 3 or the
      selling price is less than the purchase price multiplied by 2 ??

      i did this stastment but the ruselt not come with multiplied by 2 or 3 ,,

      SELECT *
      FROM stockitem
      where sellprice > purchprice *3
      or sellprice > purchprice *2
      order by stkid asc;