Sqlite3 update select

UPDATE 
      software
SET purchprice = (SELECT purchprice
                  FROM softwarecost
                  WHERE id = software.id) 
where EXISTS (SELECT purchprice
                  FROM softwarecost
                  WHERE id = software.id)

Source: stackoverflow.com

Similar codes

0 vote331 views1 answer
Query for backup a database at another location in file system
SQL
4 votes290 views2 answers
Bulk kill mysql processlist
SQL
0 vote322 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote304 views1 answer
How to update sql server version
SQL
0 vote316 views1 answer
Migration graphql
SQL
24 votes301 views6 answers
Rename a column in sql server
SQL
36 votes319 views6 answers
Delete from where sql
SQL
1 vote334 views1 answer
Alter database datafile maxsize 32g
SQL
3 votes330 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote282 views1 answer
Soql more than today
SQL