Good day,
I just want to asked regarding SQL.
let say i have a table for discount.using SQL query.
here my table name A
Item Price
A 100.00
B 200.00
C 300.00
Assume that there's 20% discount if the price is greater than 200.00 Discount should apply
- How could i create a query for that?
- Using C# or SQL statement how could i insert the record?
thanks