decimal_multiplicative_ops.sql 981 B

123456789101112131415161718
  1. USE plato;
  2. SELECT
  3. cs_ext_list_price, cs_ext_tax,
  4. cs_ext_list_price * cs_ext_tax, cs_ext_list_price * Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) * cs_ext_tax,
  5. cs_ext_list_price * decimal("13.37", 7, 2), decimal("42.0", 7, 2) * cs_ext_tax,
  6. cs_ext_list_price / cs_ext_tax, cs_ext_list_price / Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) / cs_ext_tax,
  7. cs_ext_list_price / decimal("13.37", 7, 2), decimal("42.0", 7, 2) / cs_ext_tax,
  8. cs_ext_list_price % cs_ext_tax, cs_ext_list_price % Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) % cs_ext_tax,
  9. cs_ext_list_price % decimal("13.37", 7, 2), decimal("42.0", 7, 2) % cs_ext_tax,
  10. cs_ext_list_price * Just(13), cs_ext_list_price * 13,
  11. cs_ext_list_price / Just(13), cs_ext_list_price / 13,
  12. cs_ext_list_price % Just(13), cs_ext_list_price % 13,
  13. FROM Input;