/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

4 votes354 views4 answers
Date less than in sql
SQL
5 votes326 views1 answer
Sql use database
SQL
6 votes321 views2 answers
WHERE value IS sql
SQL
19 votes353 views3 answers
How to change column type psql
SQL
0 vote343 views1 answer
Sql select all records from all tables where not empty
SQL
2 votes357 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote347 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote336 views1 answer
Oracle step procedure
SQL
4 votes333 views5 answers
Primary key
SQL
0 vote335 views1 answer
Set a default value for a column in sqlite
SQL