/SQL/Update values in select statement sql

Update values in select statement sql

Sql update from select

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.ID

Source: stackoverflow.com

Sql update record

SQL> UPDATE CUSTOMERS
SET ADDRESS = 'Pune'
WHERE ID = 6;

Source: tutorialspoint.com

Update values in select statement sql

UPDATE STATGLOB1
SET RESILI = tttt.nnn
(Select Count(ABONNE.NUMAB) as nnn From (ABONNE                                      
Inner Join ABONMENT ON ABONMENT.NUMAB = ABONNE.NUMAB)
Where ABONNE.SECTEUR='01'
And ABONMENT.ETATCPT=+QuotedStr('40')
Group By ABONNE.SECTEUR,Left(ABONNE.NUMAB,2),ABONNE.TYPABON,ABONMENT.ETATCPT) as tttt

Similar codes

33 votes281 views6 answers
Change column name in mysql
SQL
3 votes295 views2 answers
Update Query in SQL Server
SQL
0 vote268 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote276 views1 answer
Mysql update even / odd rows
SQL
2 votes293 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote232 views1 answer
Calculate discount from original price sql
SQL
0 vote302 views2 answers
Sql stored procedure for access frontend
SQL
0 vote288 views1 answer
Find usage of table in sql server
SQL
1 vote274 views1 answer
Get table which have specific columns in mysql
SQL
1 vote285 views1 answer
Oracle repeat_interval 5 minutes
SQL