jeudi 18 janvier 2018

SQL Case Reference

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