decimal_op_decimal_scalar.sql 502 B

12345678910111213141516
  1. USE plato;
  2. SELECT
  3. cs_ext_list_price + cast("10.2" as decimal(7,2)),
  4. cs_ext_list_price + cast("99999.99" as decimal(7,2)),
  5. cs_ext_list_price - cast("11.22" as decimal(7,2)),
  6. cs_ext_list_price - cast("99999.99" as decimal(7,2)),
  7. FROM Input;
  8. SELECT
  9. cast("10.2" as decimal(7,2)) + cs_ext_list_price,
  10. cast("99999.99" as decimal(7,2)) + cs_ext_list_price,
  11. cast("11.22" as decimal(7,2)) - cs_ext_list_price,
  12. cast("99999.99" as decimal(7,2)) - cs_ext_list_price,
  13. FROM Input;