Create a stored procedure out of the INVOICE table that selects a field as the sum of
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a stored procedure out of the INVOICE table that selects a field as the sum of Total and Shipping if Subtotal is less than 100 and selects a field as the Total only if Subtotal is equal or greater than 100.
MySQL format,
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date: