how to multiply in sql 1

how to multiply in sql

SELECT name,
 price*quantity AS total_price
FROM purchase;

Here is what the above code is Doing:
1. We’re selecting the name and price*quantity columns from the purchase table.
2. We’re aliasing the price*quantity column as total_price.

Similar Posts