Suppose you have a table named sales with columns id , product_name , quantity , and price . You want to update the column total_price by multiplying the quantity and price columns. Which SQL statement will achieve this?

Question

Suppose you have a table named  sales  with columns  id ,  product_name ,  quantity , and  price . You want to update the column  total_price  by multiplying the  quantity  and  price  columns. Which SQL statement will achieve this?

Accepted Answer

UPDATE sales SET total_price = quantity * price;

Answer

UPDATE FROM sales SET total_price = (quantity * price);

Answer

UPDATE TABLE sales SET total_price = quantity * price;

Answer

UPDATE sales SET total_price = quantity - price;

Crowdly

Suppose you have a table named sales with columns id , product_name , quan...

Хочете миттєвий доступ до всіх перевірених відповідей на softserve.academy?