This discussion is archived
8 Replies Latest reply: Apr 2, 2013 12:42 AM by Girish Sharma RSS

pls i need your help in my SQL Query statement

1000427 Newbie
Currently Being Moderated
Hi brothers

pls guys i need some one help me about this Question

3.1.1.
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points