/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

5 votes173 views1 answer
Oracle columns in all_tables
SQL
2 votes164 views3 answers
Copy data from one table column to another table column in sql
SQL
10 votes149 views2 answers
Mysql alter add foreign key
SQL
32 votes152 views6 answers
Sql count where
SQL
1 vote140 views1 answer
Scaffold mysql database
SQL
-1 vote103 views1 answer
Oracle db list usernames
SQL
38 votes215 views4 answers
Count sql
SQL
6 votes199 views2 answers
How to get last element sql
SQL
1 vote160 views1 answer
Sql drop schema
SQL
0 vote144 views1 answer
Connexion mysql
SQL