How to write the syntax for this question | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How to write the syntax for this question

Products that bring < $1.00 profit per purchase need to be deleted?

10th Apr 2017, 3:00 AM
Dave
Dave - avatar
5 Answers
+ 1
I am assuming you are trying to delete tuples and your table contains the profit per purchase attribute: DELETE FROM [tableName] WHERE profit < 1.00
10th Apr 2017, 3:09 AM
Deddy Tandean
+ 1
I guess you can take the (salePrice - originalPrice) < 1.00 since it is per purchase, so it is more of like individual instead of counting it weekly, monthly, or yearly as a group
10th Apr 2017, 3:23 AM
Deddy Tandean
+ 1
no problem
10th Apr 2017, 3:25 AM
Deddy Tandean
0
My table doesnt have per purchase. It has the price, weeklysale, montlysale and yearlysale
10th Apr 2017, 3:12 AM
Dave
Dave - avatar
0
Got you thanks
10th Apr 2017, 3:24 AM
Dave
Dave - avatar