/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

1 vote97 views1 answer
Sql Split string function
SQL
0 vote110 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote150 views1 answer
Sqlite display headers on columns
SQL
0 vote115 views1 answer
Mysql set boolean default value
SQL
6 votes90 views3 answers
Can you update NULL in sql
SQL
1 vote128 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote106 views1 answer
How to write if case in select query in select statement
SQL
16 votes113 views2 answers
Oracle ddl
SQL
0 vote115 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
5 votes123 views1 answer
Oracle create table comment
SQL