Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "SELECT
- CASE
- WHEN ingramCost IS NULL THEN verizonCost
- WHEN verizonCost IS NULL THEN ingramCost
- ELSE LEAST(verizonCost, ingramCost)
- END AS smCost
- FROM phonePrices"
- ;
- What i need is
- "SELECT name, model, description, maxDP
- CASE
- WHEN ingramCost IS NULL THEN verizonCost
- WHEN verizonCost IS NULL THEN ingramCost
- ELSE LEAST(verizonCost, ingramCost)
- END AS smCost
- FROM phonePrices"
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement