How to Update Table using Subqueries in SQL
In this article I am going to explain how to update table using subqueries in SQL.
Introduction
In this article I am going to explain how to update table using subqueries in SQL. A select statement known as subquery if it is codded within another SQL statement. Subquery can return a single value or a result set. This result set may contain a single column or more than one column.
There are four way to create subquery in a SELECT statement.
- In WHERE Clause
- In HAVING Clause
- In FROM Clause
- In SELECT Clause
We can update data in a table using subqueries in SQL. To update a table we can write subquery in the SET, FROM and WHERE Clause.
Data Stored in table before update operation
Statement that update data stored in table using subquery.
|
UPDATE dbo.mcninvoices
SET creadittotal = creadittotal+100,
paymenttotal = (SELECT MAX(paymenttotal) FROM dbo.mcninvoices)
WHERE dbo.mcninvoices.invoiceid=1
|
Data stored in table after update operation
