I would like to write a SQL CASE statement or other statements to resolve the following problem:
If Store = 'STORE1' then refer to Store 2's selling price else usual selling price.
I have one table called "DailySales" with columns "Date", "Store" and "SellingPrice"
Any help will be much appreciated.
Aucun commentaire:
Enregistrer un commentaire