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?