In this example, we have a table named tbl_test with three columns id, name and pwd. We want to multiply the values of id and pwd columns and return the result in a new column named product.

To do so, we use the following query:

SELECT id,name,pwd FROM tbl_test;

SELECT id*pwd FROM tbl_test;

OR

In this post, we will learn how to multiply two columns in sql?

In this example, we are going to show you how to multiply two columns in SQL.

To multiply two columns in SQL, you can use the following query.

SELECT column1 * column2 FROM table1;

Last modified: October 3, 2022